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
What are the types of optimization?
What is compiled query?
What is natural join in sql?
What is scalar function?
What are different categories of sql commands?
What is cursor and why it is required?
Is sql a microsoft product?
What is a design view?
what are myisam tables? : Sql dba
What is normalization? How many normalization forms are there?
What are the operators in sql?
Whis is not false in primary key?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
Which language is used in sql?
What are the different ddl commands in sql?
