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

Can you rename a database in mysql?

971

What is unsigned int in mysql?

889

Can you tell how many values can set the function of mysql to consider?

946

What is definer in mysql?

929

How to represent ENUMs and SETs internally?

1101

Can you tell how to find the number of rows in a resultset using php?

879

How do I change directories in mysql?

883

How does mysql store dates?

894

What is full text indexing in mysql?

913

What are enums used for in mysql?

972

What is difference between unix timestamp and mysql timestamp?

969

What is a result set object?

926

What is action query?

866

Does mysql support nosql?

869

Is mysql a nosql database?

1064