select max(salary) from emp where salary<(select max(salary) from emp)

please tell me the query to get details of the employee
having the second largest salary

Question Posted / ss

Answer Posted / ss

select max(salary) from emp
where salary<(select max(salary) from emp)

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What stored procedure would you use to view lock information?

905

What happens when converting big values to integers?

959

How you trouble shoot when any job fails

1896

Explain the truncate command? : SQL Server Architecture

1094

How to make a column nullable?

1044

What is executereader?

898

When would you use the stored procedures or functions?

950

What is proper subset of candidate key?

948

What is DCL?

979

Difference between LEN() and DATALENGTH() in sql server ?

1062

How the authentication mode can be changed?

1078

Does union all remove duplicates?

1019

Explain comment on transactions?

936

How optimize sql query with multiple joins in sql server?

829

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

970