Select max(Salary) from employeetable where salary

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

Question Posted / shivangi

Answer Posted / shivangi

Select max(Salary) from employeetable where salary < (select
max(salary) from Employeetable)

Is This Answer Correct ?

11 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the datatype of rowid?

965

What is cdc in sql server?

1046

what is raid and what are different types of raid configurations? : Sql server database administration

1105

How do I schedule a sql server profiler trace?

1028

How to find the version of sql server? : sql server database administration

1170

Explain how to integrate the ssrs reports in application?

1063

What is inline table-value user-defined function?

1165

What is a result set object returned by mssql_query()?

1230

What is ddl and dml commands?

961

What do you understand by SQL*Net?

1085

What is difference between foreign key and unique key?

1050

What is the difference between SQL notification and SQL invalidation?

1267

Does partitioning help performance?

997

Tell me something about security and sql azure?

116

What do you do in data exploration

1050