How to find third highest salary from SQL table #coding #sql #sqlqueries #shorts

preview_player
Показать описание
How to find third highest salary from SQL table #programming #sql #shorts #youtubeshorts #coding #sqlqueries
Рекомендации по теме
Комментарии
Автор

We can use Limit and offset after Order By

ChetanAdivinnavar
Автор

In this case, it will work but if two or more people have the same salary it will fail. So you need to make it more robust by adding distinct in that subquery!

jitendravishwakarma
welcome to shbcf.ru