select emp_name, salary from employee where salary = (select MAX(salary) fr

how to find 2nd highest salary in random database salary of employer.....

Question Posted / pankajbisane

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

Please Help Members By Posting Answers For Below Questions

How do I use mysql?

937

What is new mysqli?

976

Does uninstalling mysql delete database?

1091

What is the use of mysqli_fetch_assoc?

947

How do I find mysql database?

953

What are different types of queries?

1004

How many ways we can retrieve the date in result set of mysql using php?

1177

What is the latest version of mysql?

1039

Why do gaps in sequences occur?

1036

What is difference mysql and mysqli?

1013

How do you say mysql?

961

How we can create index in mysql?

1027

Do you need a license for mysql?

992

What is a procedure example?

984

What's the difference between mysql and sql server?

1045