select salary from table_name order by desc limit 3,1;

Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)

Question Posted / shashank tayal

Answer Posted / shashank tayal

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What is check constraint in sql server?

1045

What do you know about normalization and de- normalization?

968

How to use transact-sql statements to access the database engine?

1122

Can we linked SharePoint to a SQL database?

1073

What is local temp table?

1022

How many servers can we create in a single subscription?

162

What are the advantages of having an index on the sql server?

973

Explain the ways to controlling cursor behavior?

967

What is truncate table?

999

Describe how to use the linked server?

1200

List the different index configurations possible for a table?

978

Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

1003

What is normalization 1nf 2nf 3nf?

1107

How to delete duplicate rows from table except one?

1041

What are the types of indexes?

1130