how we can find nth max salary from an employe table by
using my sql?
Answer Posted / nivedita
select max(salary) from employee order by salary desc limit 1;
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How can I see connections in mysql?
What are the non-standard sql commands supported by 'mysql'?
What is information_schema in mysql?
Is there a way to see the files which are stored?
Can you tell the reasons for selecting lamp(linux, apache, mysql, php) instead of any other combination of software programs, servers, and operating system?
Explain the different types of constraints?
What is difference between Sql server and MySql database? It may be silly question but i really dont know.
What are the types of database engines available in mysql?
What are the advantages of mysql?
How to get the current date in mysql?
Explain the storage engines in mysql?
Define REGEXP?
How is oracle different from mysql?
How do I change a procedure in mysql?
Explain about reporting services of MYSQL?