how we can find nth max salary from an employe table by
using my sql?

Answer Posted / whatinaname

select max(salary) from employee
order by salary desc limit n-1, 1

Is This Answer Correct ?    14 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the types of database engines available in mysql?

477


What does mysql_query return?

501


What does mysqli_fetch_assoc do?

490


Is mysql port 3306 tcp or udp?

516


What are the applications required to support mysql?

495






Is mysql is a programming language?

527


Why mysql is used with php?

497


What is mysqlcommand?

479


Can mysql handle billions of records?

485


How does limit work in mysql?

470


Is sqlite faster than mysql?

494


What is trigger in mysql with example?

497


How to load data files into tables with 'mysqlimport'?

478


What is MySQL?

577


Explain the architecture models of SQL Server?

1902