Interested to Buy Any Domain ? << Click Here >> for more details...
how to find 2nd highest salary in random database salary of employer.....
- 4 Answers
- 7279 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
If you are assigned a task, to find the information of procedures. What are the basic commands that you will use to do so?
What is use command in mysql?
What is unsigned int in mysql?
What does mysql workbench do?
What is the use of mysqli_query?
What is save point in mysql?
What is 'mysqlshow'?
What is limit in mysql?
Is mysql owned by oracle?
Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.
What is a data directory?
How to get a version of mysql?
Differentiate CHAR_LENGTH and LENGTH?
What is the difference between a heap table and temporary table?
How to allow the user "sonia" to connect to the server from localhost using the password "passwd". Login as root. Switch to the mysql db. Give privs. Update privs.
