Find out the 3rd highest salary?

Answer Posted / suneel

select level,max(sal)from af where level=3 connect by prior
sal>sal group by level;

Is This Answer Correct ?    8 Yes 11 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to include numeric values in sql statements? : Sql dba

571


What is pl sql in oracle?

596


How do you write a subquery?

533


What is synonyms?

585


What is the difference between numeric and autonumber?

506






Who is the owner of mysql database?

562


What is the largest value that can be stored in a byte data field?

525


Why select is used in sql?

524


How does postgresql compare to mysql?

589


Is ms sql traffic encrypted?

511


How do you write an index?

535


How do you explain an index?

794


what is the difference between inner and outer join? Explain with example. : Sql dba

555


Can we commit inside a trigger?

557


Why plvtab is considered as the easiest way to access the pl/sql table?

631