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

List all the types of user-defined functions?

1186

How to delete an existing database user?

1083

what types of replication are supported in sql server? : Sql server database administration

1134

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

1036

What are the tools available in market as an alternative to sql server reporting services?

138

What is difference between table aliases and column aliases? Do they affect performance?

1021

What are secondary xml indexes?

1077

How to create and drop temp table in sql server?

1100

How to find tables without indexes?

1156

Explain triggers?

1066

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

How to create an multi-statement table-valued function?

1049

What is triggers and its types?

1069

How to join two tables in a single query in ms sql server?

1061

Why do we backup Active Directory ?

1100