Interested to Buy Any Domain ? << Click Here >> for more details...
how to find 2nd highest salary in random database salary of employer.....
- 4 Answers
- 7417 Views
- I also Faced
- E-Mail Answers
Answer Posted / pankajbisane
select emp_name, salary from employee where salary = (select MAX(salary) from employee
WHERE salary <> (select MAX(salary) from employee ))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to get the number of rows selected or affected by a sql statement?
How to dump a table to a file with 'mysqldump'?
What are the steps required to view your mysql database?
How to calculate the difference between two dates?
What are the advantages/disadvantages of mysql and php?
Is mysqli faster than mysql?
What is a deterministic function?
How to delete a trigger in mysql?
How do I stop a query in mysql workbench?
How to delete a column and add a new column to database
How to decrement dates by 1 in mysql?
How to update database permissions/privilages.
What is row level locking in access?
How can you retrieve a particular number of records from a table?
How database are managed?
