select secondMAXsal from emp WHERE seconMAXsal = ((MAXsal)-1);

how to find nth highest salary

Question Posted / sameera chiluka

Answer Posted / sameera chiluka

select secondMAXsal from emp
WHERE seconMAXsal = ((MAXsal)-1);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can you append an identity column to a temporary table?

877

how to create a scrollable cursor with the scroll option? : Sql server database administration

1027

Explain about analysis services?

982

What is report snapshot?

142

What is a field in a table?

985

What is SQL Azure Data sync?

119

Explain transaction isolation levels in sql server?

1037

What is the boxing and unboxing concept in .net?

868

Explain about protocol layer present in SQL server?

1108

What is used to replicate sessions between instances in coldfusion clusters?

1019

List few advantages of stored procedure.

928

What is the purpose of self join?

918

How can I change procedure name in sql server?

975

What is the recursive stored procedure in sql server?

968

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

874