Day 10 - Analytical | Window Functions in SQL | Oracle SQL for Beginners | Oracle SQL Tutorial

#JUSTIN#ORACLE#SQL#TAMIL#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers
========================================================
🌕Want to join WhatsApp Group? (Only technical discussion, no spam messages, no promotion msg)
📌chat.whatsapp....
🌕For more details contact me on WhatsApp [phone]) or below link
wa.link/m4lat0
========================================================
📌 Oracle 21C Installation: with software: (How to import HR Schema in Oracle 21C)
• Oracle 21c installatio...
Oracle 11g Installation:
• Oracle 11g Installatio...
==========================================================================
🔵Oracle SQL Tutorial - English
• Oracle SQL Tutorial - ...
🌕Oracle SQL - தமிழில்
• Oracle SQL - தமிழில்
📌 Oracle SQL Day wise Video: ENGLISH
Oracle SQL Day 1 - Introduction to Oracle - • Oracle SQL Day 1|Oracl...
Oracle SQL Day 2 - SQL Types DDL, DML, DRL, DCL, TCL - • Day 2 - Oracle SQL for...
Oracle SQL Day 3 - Constraints in Oracle - • Day 3 - Oracle SQL for...
Oracle SQL Day 4 - SELECT Statements in Oracle - • Day 4 - Oracle SQL for...
Oracle SQL Day 5 - Single Row Functions in Oracle - • Day 5 - Oracle SQL for...
Oracle SQL Day 6 - Joins in Oracle - • Day 6 - Oracle SQL for...
Oracle SQL Day 7 - Aggregate Functions in Oracle - • Day 7 - Aggregate Func...
Oracle SQL Day 8 - Sub Queries in Oracle - • Day 8 - Sub queries in...
Oracle SQL Day 9 - SET Operators in Oracle - • Day 9 - SET Operators ...
Oracle SQL Day 10 - Analytical Functions in Oracle - • Day 10 - Analytical | ...
Oracle SQL Day 11 - Views in Oracle - • Views in Oracle | Norm...
Oracle SQL Day 12 - Indexes in Oracle - • Index in Oracle | Norm...
Oracle SQL Day 13 - Regular Expression - • Oracle SQL Tutorial - ...
**********************************************************************************
📌 Oracle SQL Full Course in 6 hours - TAMIL
• SQL tutorial TAMIL | ...
📌Oracle SQL Day wise Video: TAMIL
-----------------------------------
Oracle SQL in Tamil - Day 1 - • Day 1 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 2 - • Day 2 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 3 - • Day 3 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 4 - • Day 4 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 5 - • Day 5 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 6 - • Day 6 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 7 - • Day 7 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 8 - • Day 8 - SQL in TAMIL |...
Oracle SQL in Tamil Day 9 - • Oracle SQL Analytical ...
Oracle SQL in Tamil Day 10 - • Views in Oracle SQL TA...
************************************************************************************
Oracle Interview questions:
sql interview questions and answers,
sql server interview questions and answers,
sql questions and answers,sql interview questions for testers,
sql interview questions for freshers,sql interview questions pdf,
sql interview questions for beginners,sql interview questions,
sql interview questions for data analyst,
sql interview questions youtube,
sql interview questions for business analyst,
sql interview questions for experienced,
interview questions sql,
oracle interview questions,
sql interview questions,
top 50 oracle interview questions,
oracle interview questions ,
oracle pl sql interview questions and answers,
intermediate level sql interview questions,
oracle dba interview questions and answers,
top 50 oracle interview questions ,
oracle interview questions for experienced,
interview questions sql,
sql interview questions and answers,
sql interview questions for freshers,
sql interview preparation
==========
SQL Notes:
==========
Oracle SQL Day 10 - Analytical Functions in Oracle
drive.google.c...

[@NICITACADEMY]

*Complete 48 hours of Self-Paced Courses and Interview Questions Links:*
courses.nicitacademy.com/
Are you interested in joining my Live training? or Self-Paced course?

You can visit our website for more details.
www.nicitacademy.com/
Contact me for more details @ 🌕 wa.link/m4lat0
*WhatsApp group:*
chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0
Thanks,
NiC IT Academy
=======================================================================
🔵Oracle SQL Tutorial - English
ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
ua-cam.com/video/C1zGVRFM3-A/v-deo.html
📌*Informatica Full Course:*
ua-cam.com/video/V2FtZ_INmjg/v-deo.html
📌*SQL Full Course:*
ua-cam.com/video/iuvzjf7nU1I/v-deo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
ua-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
ua-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
ua-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
ua-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
ua-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks

[@allmedia656]

First time I learned SQL/ETL by you and got job. THis second time that I'm learning your lessons. Its so clear and you make easy to understand PL/SQL better. Thank you RAJ

[@georgehall2882]

I just ran across your channel and I wanted to say thank you. Great, informal videos.

[@NICITACADEMY]

Glad you like them!

[@krishnanselvam786]

Thank you so much sir.

[@NICITACADEMY]

Most welcome

[@shathabdhir]

3. Which is the top transaction in each day.;
select *
from (select TRANS_DATE, TRANSACTION_ID, ACCOUNT_NO, NAME, CR_DR, AMOUNT,BALANCE_AMOUNT,
rank() over(partition by TRANS_DATE order by amount desc) as trans from transactions)
where trans = 1 ;
is this correct for 3rd question , the Querry is missing in the excel sheet

[@thehero3974]

Sir Thank you so much.... please upload Views video soon

[@NICITACADEMY]

Ok sure

[@crazygirl-rz5ot]

sir pls post the next videos...I'm learning lot in easy way from your videos

[@NICITACADEMY]

Will upload soon

[@kalairaju8739]

Sir we need plsql class in a single video like this.It will be very helpful for us sir

[@NICITACADEMY]

Will upload soon

[@hasanmougharbel8030]

Hey there, god bless your efforts in this channel.
As a newbie sql learner i have general enquiry.
What is the major difference between Oracle database and mysql database.
Is there any advantages i need to consider before choosing to work on one of them.
Thanks for taking care of this.

[@NICITACADEMY]

Hi, Thanks for your wishes.
MySQL is open source DB, and Oracle is Paid DB server.
But SQL is almost same for both DBs. So please start learning Oracle SQL.

[@kavyaannam1489]

Thank you for the new vedio sir
Please 🙏 upload all the tutorials

[@NICITACADEMY]

Sure 👍 Keep watching. Thanks for your follow up.

[@jai7104]

THANKING SO MUCH FOR MAKING VIDEO'S

[@NICITACADEMY]

Welcome

[@praneetnema7683]

thank you sir
waiting for other vedios to upload

[@NICITACADEMY]

Keep watching

[@sdr9688]

Good explain thank you sir plz more videos

[@NICITACADEMY]

Sure I will

[@sabeerrookie862]

we need to change IT domain sir how to contact you sir.

[@NICITACADEMY]

please send mail to [e-mail] or please check description of the video.

[@lakshmiprasanna4227]

We want Manual testing explanation sir

[@NICITACADEMY]

I will try

[@sabeerrookie862]

Please do more sql topics sir like synonyms, sequence and roll up

[@soundaryakota7579]

Yes Sir Please

[@mrtharunprao]

Sir can you please upload the remaining lectures. It will be a great help sir...
And can you please upload a real time project with an end to end project.
Thank you for your video

[@NICITACADEMY]

I will try my best

[@mrtharunprao]

@@NICITACADEMY
Thank you sir. Will be waiting for an end to end project with an explanation👍.

[@malikbasha4797]

thankyou sir

[@Cheybanala]

Hi Sir can you please make a video on performance running techniques with examples

[@NICITACADEMY]

Yes, soon

[@technicalfact8390]

Sir, please complete oracle sql series . You have mentioned 20 videos but there is only 10 videos.
I am learning through your video step by step.
I need your video sir.

[@NICITACADEMY]

Sure. I ll do

[@technicalfact8390]

Thanks sir

[@amitprasad5471]

sir very nice content.👍👍
but still we are waiting for remaining video.

[@NICITACADEMY]

Please join my live training

[@premkumar-yb7vt]

Hi sir
Sir can u explain ( index and cursor) also sir plz
And n-varchar also sir

[@NICITACADEMY]

Sure

[@kuttiesgalattavlogs4589]

Hi sir..please upload about collections

[@NICITACADEMY]

Will do soon

[@teddyteddy6044]

Sir plz upload remaining 10 videos out of 20

[@PandiyanSEce]

How we can access other remaining 10 Oracle SQL videos

[@NICITACADEMY]

Please check the description and playlist.

[@PandiyanSEce]

Playlist also available for day 10 alone. Description also given upto day 10 sir.
Please share

[@WisdomWomenWarrior]

Sir, Kindly upload 11th onwards videos

[@NICITACADEMY]

Sure, I will upload

[@mamathareddy4986]

sir please upload remaining videos of this

[@NICITACADEMY]

Sure I will do

[@krishnanselvam786]

please post video listagg() funtions sir.

[@NICITACADEMY]

Thanks for your continuous follow up. I will post all your questions.

[@krishnanselvam786]

@@NICITACADEMY thank you so much sir.

[@user-xc4fw6ko2q]

i want plsql bro please upload videos

[@saireddyksr]

Waiting for 11 video Sir

[@NICITACADEMY]

Very soon

[@thehero3974]

Sir Thank you so much.... please upload Views video soon

[@NICITACADEMY]

Ok sure

[@thehero3974]

Sir Thank you so much.... please upload Views video soon

[@NICITACADEMY]

Ok sure