Answer / saritha

select distinct top 2 salary from EMP order by salary desc

Answer / adiseshu

select * from (
select dense_rank() over (order by salary desc) rno,* from
employees ) as a where rno in(1,2)

Answer / mohan c v

select min(salary) from
(select top 2 salary from phani order by salary desc) as a

Answer / tanay chaudhary

select * from(select emp.*,Dense_Rank() over(order by salary desc) as ranking from emp)as e where e.ranking in(1,2)

//emp=table name
//salary=column name

Answer / santosh kumar

select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
desc.

Answer / santosh kumar

select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
asc.

Answer / ram murthy

SELECT TOP 1 salary FROM (SELECT DISTINCT TOP 2 salary FROM
employee ORDER BY salary DESC) a ORDER BY salary

Answer / neeraj sharma

select ename,sal from emp where rownum<=3 order by sal desc

Note:- every table has rownum column but it is hidden by
default you can see it by this
select rownum from your_table_name

Answer / vijayalaxmi m khot

select max(sal) from emp where sal=(select max(sal) from emp
where sal<(select max(sal) from emp));

Answer / shahid

select * from(select * from Employee order by salary desc) where rowNum<3

What is the joins and how many types of Joins in sql server a diffrentiate ever one give a suaitable query

2 Answers   Apollo,

Can we use trigger new in before insert?

0 Answers  

What is the difference between drop table and truncate table?

0 Answers  

How to get a list of columns using the "sys.columns" view in ms sql server?

0 Answers  

Does the order of columns in update statements matter?

0 Answers  

What is the data type of time?

0 Answers  

What is the use of MOVE keyword in restore command

3 Answers   IBM,

If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

What is checkpoint in sql server?

0 Answers  

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

Which are new data types introduced in sql server 2008?

0 Answers  

List the different types of joins?

0 Answers