select salary from employee where salary>(select max (salary) from empl

how to find nth highest salary

Question Posted / vijay dev arya

Answer Posted / vijay dev arya

select salary from employee where salary>(select max
(salary) from employee)

Is This Answer Correct ?

6 Yes

17 No

Please Help Members By Posting Answers For Below Questions

What are unicode character string data types in ms sql server?

1346

What is the difference between nvl and nvl2?

1028

Explain the properties of the relational tables?

1031

How do we synchronize On-Premise SQL server with SQL Azure?

124

What is difference between group by and having?

995

What is exporting utility?

1086

If a table does not have a unique index, can a cursor be opened on it?

959

what are isolation levels? : Sql server database administration

1060

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

1052

How to update a field in SQL after ALTERING a row?

1286

How to truncate the log in sql server 2012? : sql server database administration

1346

Does view occupy space?

992

Why does sql studio use a single registered database repository? : sql server management studio

1040

What is sql server programming?

1091

What is delete query?

991