3. Rank Scores Leetcode (Medium) | SQL For Interviews | SQL Tutorials

#sql #sqlforinterviews #dbms

Hello viewers,

In this video, we have discussed a very interesting query that is frequently asked in interviews. The query involves the use of a co-related query.

SQL is considered as the most important part of an interview.

Your technical managers will always want you to put a lot of effort when it comes to writing a flexible SQL query while developing web apps or software.

Extra video covers:

SQL for Interviews
InfyTQ SQL Preparation
SQL for Product-based companies
SQL in DBMS
Learn SQL
Second Highest Salary
Nth Highest Salary

[Riyamishraofficial]

Thanku so much sir for giving this video

[historyexplorer]

Nice video, can you also make a video on hackerrank problem " Weight Uniform String ".

[ashutoshkund]

select score, dense_rank() over (order by score desc) as 'rank' from Scores;

I feel this query is simpler than corelated ....

[khushiseth]

Sir please make complete sql playlist from basic to advance level

[biswadeepdatta]

select score, dense_rank() over(order by score desc) as 'rank' from Scores. work smart

[ragnarlodhbrok]

how count function works without group by clause?please explain, very confused

[meenayegan]

how about dense_rank window function ?