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

Can you roll back the ddl statement in a trigger?

516

What is the difference between clustered and non-clustered indexes in ms sql server?

479

What are the different types of locks in the database?

480

Can group by and orderby be used together?

586

What are magic tables in sql server?

617

What are the results of running this script?

501

What is the beast way to write CTE in SQL Server ?

553

What is apply operator in sql?

554

Can a rule be bound to any column of any data type?

553

What is a non equi join?

530

What happens when transaction log is full?

502

List out a number of the wants to setup a SQL Server failover cluster?

574

Can a table have 2 foreign keys?

495

What do mean by xml datatype?

607

Explain the use of containers in ssis and also their types?

520