select max(salary) from (select salary from table1 where salary<(select

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 / prathapshankarshiva

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

Answer Posted / prathapshankarshiva

select max(salary) from (select salary from table1 where
salary<(select max(salary) from table1))

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is #temp and @table variable in SQL server?

1024

What are the system database in sql server 2008?

974

Explain what is analysis service repository?

922

What do you understand by user-defined function in the sql server?

897

What are approximate numeric data types in ms sql server?

1001

How many replicas are maintained for each SQL Azure database?

140

What do you understand by mirroring?

951

What are “lost updates”?

948

How do I edit a procedure in sql server?

897

What are the steps to process a single select statement?

884

How does normalization work?

864

What is transaction server consistency?

979

What is #table in sql server?

994

Does hive support indexing?

905

What is a cube? : sql server analysis services, ssas

943