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 an example of a primary key?

993

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

1009

Can sql server be linked with other servers like oracle?

968

What are page splits? : SQL Server Architecture

993

After removing a table from database, what other related objects have to be dropped explicitly?

1058

Why should one not prefix user stored procedures with ‘sp_’?

1048

Why are views required in the sql server or in any other database?

965

What are the properties of primary key?

976

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

944

What is the name of reporting services config file and what’s it’s used for?

146

How to use "begin ... End" statement structures in ms sql server?

1050

Explain what are the different index configurations a table can have?

1114

What is sql collation?

1215

How global temporary tables are represented and its scope?

977

Differentiate sql server reporting services vs. Crystal reports?

203