Answer Posted / madhu
to get nth higest value
SELECT EMP_NAME,EMP_SALARY
FROM EMP_TABLE
ORDER BY EMP_SALARY DESC
LIMIT n-1, 1
this is for mysql server
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to define a procedure inside another procedure?
What are the restrictions on external table columns?
How to resolve name conflicts between variables and columns?
When do I need to use a semicolon vs a slash in oracle sql?
What happens to the indexes if a table is recovered?
Can you assign multiple query result rows to a variable?
Explain the function of optimizer in oracle?
What privilege is needed for a user to delete rows from tables in another schema?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to write a query with a left outer join in oracle?
what is port in oracle? how is it related to database application.
What is a nvl function?
Can we call procedure inside function in oracle?
What is a package ? What are the advantages of package ?