select Top2(salery)from (select Top3 (salery) from tab1 order by salery D

what is syntex second or third highest salary.

thanks & Regards
Dhirendra sinha

Question Posted / anil tiwari

Answer Posted / anil tiwari

select Top2(salery)from (select Top3 (salery) from tab1
order by salery DESC)order by salery.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many triggers you can have on a table?

953

where the connection string store in the database

2033

How to get nth highest salary from employee table.

1118

What is stored procedures?

977

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

1075

What happens if null values are involved in string operations?

937

System variable and temporary variables

2192

Do you know what is a with(nolock)?

1013

Explain why variables called the most powerful component of ssis?

1017

How to modify an existing stored procedure in ms sql server?

1032

What happens when converting big values to numeric data types?

1055

What is trigger in salesforce?

917

What is command parameter in ssrs?

157

What is indexing a document?

982

What is precedence constraint?

946