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

Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,

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

0 Answers  

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

What is difference between index seek vs. Index scan?

0 Answers  

Is it possible to create a stored procedure that runs a query and outputs the results to a text file and allows me to add extra delimeters and static field info. If so How?

1 Answers  

What is multi-statement table-value user-defined function?

0 Answers  

How to create a ddl trigger using "create trigger" statements?

0 Answers  

Can we rollback records deleted by a truncate statement?

3 Answers   CarrizalSoft Technologies, United Healthcare,

What is an indice?

0 Answers  

you are provided with the single table having say 4 col ie fname lname age city , now the all records with displying of only fname and lname is required but in this format say my name is abhay khanna it will come like this abhay-khanna rahul-roy gaurav-singh the above format is required

3 Answers  

how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,

Which data type columns are the best candidates for full-text indexing?

0 Answers