write a query to find 4th max salary

Answer Posted / nishi.swain@gmail.com

select distinct sal from table_name t1 where 4=(select count(distinct sal) from table_name t2 where
t1.sal<=t2.sal);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by field in sql?

787


What is synchronized subquery?

824


What are the benefits of pl sql?

769


What is pl sql quora?

823


What is a nested table in word?

705






Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

903


Is stored procedure faster than query?

732


What is the example of procedure?

678


What is rownum and rowid?

761


Why we use cross join?

703


How do I find duplicates in sql?

689


What is sql architecture?

747


What is pl sql collection?

694


What is sqlite used for?

699


How global cursor can be declare with dynamic trigger ?

1945