Find out the 3rd highest salary?
Answer Posted / tathagoto
select min(sal) from (select sal from (select sal from
salary order by sal desc) where rownum <
4);
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
how to shutdown mysql server? : Sql dba
What are literals in sql server?
how to use in conditions? : Sql dba
What is indexing in sql and its types?
What is scalar and vector?
How many sql statements are used?
What packages(if any) has oracle provided for use by developers?
How do I upgrade sql?
What are the benefits of triggers?
how does a local variable is defined using t-sql? : Transact sql
Can you do multiple joins in sql?
What is foreign key and example?
What is the difference between numeric and autonumber?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
how to get a list of all tables in a database? : Sql dba