how we can find nth max salary from an employe table by
using my sql?
Answer Posted / jithu
Another way is::
SELECT sal FROM sal a WHERE n = ( SELECT count(*) FROM sal
b WHERE b.sal < a.sal)
Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to create a table index in mysql?
How much does mysql cost?
What happens if you no create privilege in a database?
What is dbms in mysql?
Is there a free mysql?
What is join in mysql? What are the different types of join?
How can we get total number of records by query in mysql?
What are procedures in mysql? Explain
Is mysql server free?
How does mysql encrypt passwords?
What are the steps required to view your mysql database?
suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?
What are the types of queries?
Can you tell what are various ways to create an index?
Can a table have multiple primary keys?