Select top 1 salary from (select distinct top 2 salary from employee order

Write a query to get 2nd maximum salary in an employee table ?

Question Posted / swapnil tikale

Answer Posted / swapnil tikale

Select top 1 salary from (select distinct top 2 salary from employee order by salary desc) as sal order by salary ;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

how to create a table index in mysql? : Sql dba

1057

What are the packages in pl sql?

1009

What are stored procedures used for?

999

What is memory optimized?

1076

What is pls_integer in pl sql?

1100

What is thread join () in threading?

1005

Explain what is table in a database?

1055

what is sp_pkeys? : Transact sql

1149

What is pl sql variable?

980

How to check if a column is nullable before setting to nullable?

1121

What are sql functions? Describe the different types of sql functions?

1139

How to run pl/sql statements in sql*plus?

1073

Can sql developer connect to db2?

1037

Explain alias in sql?

1039

What is field delimiter?

1042