A little correction: sol2> select salary from emp order by salary des

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

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

Answer Posted / yogesh

A little correction:

sol2> select salary from emp order by salary desc limit 1,1;

select salary from emp order by salary desc limit n-1,1;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain trigger and trigger types?

929

What are the different ways you can create databases in sql server?

1068

How do you create an execution plan?

909

What is a db view?

865

What is master database? : SQL Server Architecture

970

can you implement data mining in SSRS?

142

How to disconnect from a sql server using mssql_close()?

1048

What are views used for?

984

Where are sql server user names and passwords stored in sql server?

1039

What is catalog views?

1039

Explain the purpose of indexes?

927

What is the use of for clause?

1061

Characterize join and name diverse sorts of joins?

937

If user is owning any SQL Objects, can we drop that user

2029

Is foreign key a primary key?

1012