Select Top 1 salary from(select top 2 salary from emp

write the query for find the top 2 highest salary in sql
server

Question Posted / chandan kumar

Answer Posted / chandan kumar

Select Top 1 salary from(select top 2 salary from emp_table
order by salary asc)

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to use column default values in insert statements in ms sql server?

1104

Write a sql query to sort on different column name according to the parameters passed in the function?

964

Define indexes?

1096

What is Sqlpaging in SqlServer 2005 ?

1115

Explain why variables called the most powerful component of ssis?

1176

How can I check that whether automatic statistic update is enabled or not?

1097

What are system databases in ms sql server?

1126

What are the differences between DDL, DML and DCL in SQL?

1281

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

1053

Find first and last day of current month in sql server

1082

Do you know what is normalization of database? What are its benefits?

1207

What is the maximum row of a size?

1071

What is the security model used in sql server 2005?

1071

What are the Advantages of using CTE in sql server?

1167

What is coalesce and check constraint in sql server?

1179