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 / eswar

Answer Posted / eswar

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

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the difference between for trigger and after trigger?

1163

How do I edit a stored procedure in sql server?

972

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1214

What is use of @@ spid in sql server?

1275

Why is replication required on the sql server?

1107

Do you know what is bit data type and whats the information that can be stored inside a bit column?

1001

How to download and install sql server 2005 books online?

1282

What is the difference between index seek vs. Index scan?

1066

What is scalar user-defined function?

1189

Explain how many normalization forms?

1077

What are SSL and TSL protocols?

1034

How to rebuild the master database?

1138

What is filter index?

995

What is user-defined inline table-valued function?

1005

What do you mean by cardinality?

945