Interested to Buy Any Domain ? << Click Here >> for more details...
how to find 2nd highest salary in random database salary of employer.....
- 4 Answers
- 7288 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
Is mysql a database?
Can you tell which of the following where clauses is faster?
How to return query output in html format?
In which year mysql created?
What is new mysqli?
What is the difference between myisam dynamic and myisam static in mysql?
What is the insert?
Where does mysql store data?
How to represent ENUMs and SETs internally?
What are the ways in which you can retrieve data in the result set of mysql using php?
How can I create table in mysql?
Can I copy mysql data directory?
What is unsigned int in mysql?
Can a table have multiple primary keys?
What are the differences between char and varchar?
