how to check the 3rd max salary from an employee table?
Answer Posted / manish_patil
select sal from emp_sal where rownum = 3 order by sal desc
| Is This Answer Correct ? | 6 Yes | 9 No |
Post New Answer View All Answers
Define join and name different types of joins?
what are the different tables present in mysql? : Sql dba
How do I partition a table in sql?
What is the most restrictive isolation level? : Transact sql
How much does sqlite cost?
Is postgresql a nosql database?
What is ttitle and btitle?
Why do we use cursors?
What is record variable?
Which command is used to delete a trigger?
what is innodb? : Sql dba
what is the stuff function and how does it differ from the replace function? : Sql dba
what are rollup and cube in t-sql? : Transact sql
Is primary key always clustered index?
What is auto increment feature in sql?