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

#JUSTIN#ORACLE#SQL#TAMIL#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers
=====================================================================
📢Dear Techies,
Do you want to join SQL/PLSQL Interview preparation, job search Group?
🔵Please join in the WhatsApp group for an update
chat.whatsapp.com/Gjv1mone1bd...
🌕For Live PLSQL training contact me on WhatsApp [phone]) or below link
wa.link/m4lat0
🔵 It is Job based - Live online training session
🔵 100% Job assistance, Real time training.
🔵 Resume preparation, Interview preparation supported.
🔵 Project explanation, Mock interviews will be taken.
1. Interview preparation, mock interview taken
2. Low cost training
3. Job Assistance
4. Have 14+ yrs of IT Exp
5. Job Oriented Training
6. Life time video recording access
(📢📢Trainer: Chandra - A Tableau and Informatica certified Professional)
📌Having 14+ years of IT experience in Banking, Insurance and Retail domain
📌Taking Training last 8+ years
📌Handled corporate and Live training sessions
========================================================
In this video we will learn Analytical Functions in Oracle SQL
denserank in sql,rank and dense_rank example,rank vs dense_rank in sql server 2008,rank dense_rank row_number in sql server,row_number vs rank vs dense_rank in sql server,rank in sql,rownumber in sql,denserank,dense_rank vs rank vs row_number sql server,sql server difference between rank and dense_rank,sql server interview questions and answers,sql questions for interview,sql server interview preparation
mysql in tamil,sqlite in tamil,sql query in tamil,oracle in tamil,sql ddl dml tamil,sql in tamil,sql course in tamil,rdbms in tamil,learn sql in tamil,sql video tutorial,sql basics in tamil,sql server in tamil,insert into query tamil,db browser for sqlite in tamil,sql queries in tamil,sql introductions,rdbms video for tamil,what is dql in sql,select query tamil,sql funtion in tamil,sql server rdms in tamil,sql server tutorial in tamil
oracle sql interview questions,
oracle interview questions,
oracle interview questions,
sql interview questions,
oracle pl sql interview questions and answers,
sql interview questions pdf,
sql interview questions,
common sql interview questions,
top 50 oracle interview questions,
intermediate level sql interview questions,
oracle interview questions for experienced,
oracle dba interview questions and answers
*****************************************************************************************************
Oracle SQL - Complete tutorial Playlist
• Oracle SQL - தமிழில்
*****************************************************************************************************
Oracle PL/SQL - Complete tutorial Playlist
• Oracle PLSQL Training ...
*****************************************************************************************************
Oracle SQL Day wise Video:
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...
*****************************************************************************************
PLSQL Session 1:Indroduction
• Oracle pl sql tutorial...
PLSQL Session 2:DML Statement
• Session 2 - DML Statem...
PLSQL Session 3:IF and Case Statement
• PLSQL Session 3 - IF a...
PLSQL Session 4:Looping Statements
• Looping statements in ...
PLSQL Session 5: Anchored datatype in PL/SQL %TYPE %ROWTYPE
• Anchored datatype in P...
PLSQL Session 6: Stored Procedure
• Session 6 - Stored Pro...
***********************************************************************************************
oracle pl sql tutorial in tamil,pl sql training online,oracle in tamil,oracle pl sql real time projects,oracle pl sql tutorial for beginners,best pl sql training institutes in chennai,pl sql videos in tamil,oracle pl sql interview questions,oracle pl sql full course,oracle real time scenarios,plsql function,oracle sql for beginners,oracle - plsql - introduction,best pl sql course online,package in plsql,plsql tutorial oracle
Oracle Interview questions:
==========
SQL Notes:
==========
drive.google.com/file/d/11kKE...

[@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

[@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

[@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 .😊

[@amruthaa9907]

Thanks for your proper explanation for oracle

[@NICITACADEMY]

You're most welcome

[@krishnanselvam786]

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

[@krishnanselvam786]

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

[@NICITACADEMY]

Most welcome

[@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;

[@rjalloverworld6815]

Sir normalisation topic missing sir so pls. Uploaded normalisation video

[@rajkumarr6832]

super thank u so much

[@NICITACADEMY]

Thank you too

[@vasanthakumar7830]

I need corelated subquery in Tamil sir

[@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.

[@balachandar57able]

Sir replication video podunga sir

[@Kalai11223]

Supper Sir, it is useful

[@NICITACADEMY]

Thanks and welcome. Keep watching my channel.

[@Rsg2820]

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

[@NICITACADEMY]

Sure.