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
how to include numeric values in sql statements? : Sql dba
What is pl sql in oracle?
How do you write a subquery?
What is synonyms?
What is the difference between numeric and autonumber?
Who is the owner of mysql database?
What is the largest value that can be stored in a byte data field?
Why select is used in sql?
How does postgresql compare to mysql?
Is ms sql traffic encrypted?
How do you write an index?
How do you explain an index?
what is the difference between inner and outer join? Explain with example. : Sql dba
Can we commit inside a trigger?
Why plvtab is considered as the easiest way to access the pl/sql table?