select * from my_table1 where sal not in (select max(sal) from my

How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database

plz mail the answer @ mak2786@gmail.com

Question Posted / harsha

35 Answers
60272 Views
Oracle, Scend, TechInfini, I also Faced
E-Mail Answers

Answer Posted / harsha

select * from my_table1 where sal not in (select max(sal)
from my_table1) order by Sal desc

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to copy the tables, schema and views from one sql server to another?

1051

What is a view in sql?

979

How to write an inner join with the where clause in ms sql server?

1094

Do you know what is similarity and difference between truncate and delete in sql?

1010

What is temporary stored procedure?

952

Please illustrate physical database architecture? : SQL Server Architecture

992

Why truncate is ddl command?

1069

How do I find my localdb version?

989

Which are ddl commands?

1055

What is the use of nvl work?

1009

whats the maximum size of view state??

2193

What is a mutating table error and how can you get around it?

1054

What is field in algebra?

1041

What is a document index?

1035

What is a collation in ms sql server?

1094