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 acid properties?

1023

What is the fastest way to permanently delete a 1 million row table named customers?

1156

What is database isolation in sql server? : sql server database administration

1026

Explain transaction server isolation?

982

What is use of dbcc commands?

1021

what is new philosophy for database devises for sql server 7.0? : Sql server database administration

953

What is service broker?

957

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

1266

What new data source types were added in ssrs 2014?

154

What is the difference between functions and stored procedures?

1093

How to list all objects in a given schema?

987

What are the types of ssrs?

139

Can I use sql azure as a backup with log shipping or database mirroring?

156

What does the on update no action do?

965

Mention what are the core components of ssrs?

296