select salary from user order by salary desc LIMIT 1, 1

1. How to fetch all the duplicate records from the table.

2. How to fetch the second highest salary from the table.

Question Posted / anbarasan k kanagaraj

Answer Posted / anbarasan k kanagaraj

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Other than truncate statement, which other command can by-pass the trigger on the tables?

1193

How to modify an existing user defined function?

1171

What is dbcc command in sql server?

1152

How to filter out duplications in the returning rows in ms sql server?

1218

What are the restrictions while creating batches in sql server?

1119

Write the syntax for stuff function in an sql server?

1074

What extended events?

1062

Can two tables share the same primary key?

987

What is blocking and how would you troubleshoot it? : sql server database administration

1097

What Is Rdbms?

1240

What are alternate keys?

1033

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

187

What is de-normalization in sql database administration? Give examples?

1027

what are the new features introduced in sql server 2000? : Sql server database administration

980

What are the difference between primary key and unique key? : sql server database administration

992