For third highest salary u can use this syntax select min(cin) from ( s

how to find nth highest salary

Question Posted / raman sharma

Answer Posted / raman sharma

For third highest salary u can use this syntax

select min(cin) from ( select distinct cin from
cws.usertable order by cin desc ) where rownum<4

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of stored procedure in sql server?

933

What is the order in which the sql query is executed?

994

What is the difference between join and inner join?

1074

What are the key configuration files for sql server reporting services ?

171

can a database be shrunk with users active? : Sql server administration

1063

Can a function call a stored procedure in sql server?

1005

what are the new features in SSRS?

147

How to create function with parameter in sql server?

1158

What is difference between equi join and inner join?

1041

What are logical/boolean operations in ms sql server?

1104

How to filter records of table in SQL SERVER?

1134

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1174

How do you rebuild an identity column?

997

What are the types of indexing?

1119

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

1010