Oracle SQL Analytical Functions | SQL Tutorial in TAMIL| Rank(), Dense Rank in Oracle SQL

[@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
th-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
th-cam.com/video/C1zGVRFM3-A/w-d-xo.html
📌*Informatica Full Course:*
th-cam.com/video/V2FtZ_INmjg/w-d-xo.html
📌*SQL Full Course:*
th-cam.com/video/iuvzjf7nU1I/w-d-xo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
th-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
th-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
th-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
th-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
th-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
th-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
th-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks

[@nag1102]

Unbelievably fantastic, u made the concept very easy, in all the videos u give an overview of when to use it, where, and then how. That’s what makes ur videos stand out. Thank you for making it in Tamil.

[@nag1102]

Over() ku oru explanation kuduthingala I won’t forget ever. I watched many videos b4, I didn’t get the use of over() anywhere. I love to give million likes for that one explanation

[@NICITACADEMY]

You're very welcome! Thank you very much. Keep watching my channel.

[@clintonm9665]

1.top balance amount of each person
select*from
( select cust_name,balance_amount,rank()over(partition by account_no order by balance_amount desc) rnk from bank) where rnk=1;
2.select latest 5 transaction for each account
select*from
( select cust_name,balance_amount,trans_date,row_number()over(partition by account_no order by trans_date desc) rnk from bank) where rnk

[@amruthaa9907]

Thanks for your proper explanation for oracle

[@NICITACADEMY]

You're most welcome

[@krishnanselvam786]

How to answer about UNIX COMMENT while PLSQL interview questions will be asked frequently important Unix comments .please post this video sir.i am kindly requesting sir.i am expecting for this video....will you upload this perticular video it will be usefull one to everyone during in interview time .thank you.....for the all effective videos in easy to understand in Tamil way .😊

[@dhianeshkumar4003]

3.) select * from
(select Trans_date,transaction_id,account_no,amount,
rank() over(partition by trans_date order by amount desc) as "amt_rnk"
from employees) where amt_rnk=1;

[@shobananarayanan6529]

--select top 3 bal amount
select * from(select e.*,rank()over (order by bal desc)rnk from transaction e)where rnk

[@NICITACADEMY]

Good, keep up your good work.

[@krishnanselvam786]

Thank you so so mach sir.....😊😊😊😊😊😊😊😊

[@NICITACADEMY]

Most welcome

[@krishnanselvam786]

Sir missing listagg () function in analytical functions.pleast post subract video sir. Or with pivot and unpivot topic...

[@rjalloverworld6815]

Sir normalisation topic missing sir so pls. Uploaded normalisation video

[@rajkumarr6832]

super thank u so much

[@NICITACADEMY]

Thank you too

[@balachandar57able]

Sir replication video podunga sir

[@Kalai11223]

Supper Sir, it is useful

[@NICITACADEMY]

Thanks and welcome. Keep watching my channel.

[@vasanthakumar7830]

I need corelated subquery in Tamil sir

[@Rsg2820]

Sir please make this vidoe in English ASAP 🙏🙏..we need this video fast.please🙏

[@NICITACADEMY]

Sure.