Interested to Buy Any Domain ? << Click Here >> for more details...
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
who introduced sql?
How do we accept inputs from user during runtime?
Is natural join and inner join same?
How can you fetch first 5 characters of the string?
Why we use triggers in mysql?
What are the different datatypes available in PL/SQL?
How can you create an empty table from an existing table?
Mention what is the use of function "module procedure" in pl/sql?
What is difference between table and view?
How many rows can sqlite handle?
What is trigger explain it?
what is the use of double ampersand (&&) in sql queries?
What are the types of operators available in sql?
What is dml and ddl?
What is sql rowcount?
