select sal,rownum from (select sal from emp order by sal desc) where row

what is syntex second or third highest salary.

thanks & Regards
Dhirendra sinha

Question Posted / dipti saxena

7 Answers
9566 Views
I also Faced
E-Mail Answers

Answer Posted / dipti saxena

select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=3
MINUS
select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=1

Is This Answer Correct ?

0 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain filtered indexes benefits?

954

Can we insert data into a view?

1066

Give me a SQL Query to find out the second largest company?

1122

What is join and name different type of joins?

976

What are the types of lock supported by ?

996

OPTIMIZATION OF SP,CURSOR,TRIGGERS

2708

How to remove duplicate rows from table except one?

941

What are the different types of upgrades that can be performed in sql server?

1120

How to use linked server?

1088

Differentiate between mongodb vs. Sql server?

1035

Explain where clause?

935

What type of locking occurs during the snapshot generation? : sql server replication

1264

Explain the properties of sub-query in sql server?

956

What are the functions in sql server?

903

Where can you add custom error messages to sql server?

1055