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

Explain comment on transactions?

0 Answers  

What are subquery and its properties?

0 Answers  

What are the types of table?

0 Answers  

How to drop an existing schema in ms sql server?

0 Answers  

Where does the copy job runs in the log shipping primary or secondary? : sql server database administration

0 Answers  

What are the different types of Indexes available in SQL Server?

0 Answers  

You want to implement the one-to-one relationship while designing tables. How would you do it?

0 Answers  

find the 3rd max salary

10 Answers  

Explain the purpose of indexes?

0 Answers  

what is the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

0 Answers  

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers