Answer Posted / imran ansari
find n th highest salary replace n with 1,2,3....to find second,third,fourth........sal
SELECT sal from emp order by sal desc limit 2,1
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is pl/sql table? Why is it used?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
Write a unique difference between a function and a stored procedure.
What is the sql*loader? : aql loader
What are tables and fields?
What is the difference between mdf and ndf files?
What pl/sql package consists of?
Can we use ddl commands in pl sql?
What does count (*) mean?
How do I delete a trigger?
what are the 'mysql' command line arguments? : Sql dba
What is composite primary key in sql?
What is a table?
What is nosql db?
What is scalar function?