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
How do I run sql?
Is join an inner join?
What is sql*loader and what is it used for?
Can a foreign key be null?
Why primary key is required?
How can you tell the difference between an index and a view?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is the purpose of cursors in pl/sql?
Why cross join is used?
Which tcp/ip port does sql server run?
What is the location of pre_defined_functions.
Is sqlite free?
Why sql query is slow?
What is trigger explain with example?
How to sort the rows in sql.
