Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 35 Answers
- 60218 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / ashish kumar
To find nth maximum salry
Select salary from tbl_name a where
n-1=(Select count(distinct(count(*))) from tbl_name b
where b.salary>a.salary)
| Is This Answer Correct ? | 10 Yes | 20 No |
Post New Answer View All Answers
List out the different types of locks available in sql server?
What are cascading parameters in ssrs reports?
List the different index configurations possible for a table?
What is difference between line feed ( ) and carriage return ( )?
What is intellisense?
What is a ddl statement?
What is the full meaning of dml?
What is the purpose of indexing?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
What are trace flags?
Explain what are various ways to enhance the ssrs report?
What is the difference between char and varchar2 datatype in sql?
What are the steps to process a single select statement?
When multiple after triggers are attached to sql table, how to control the order of execution?
What are binary string data types in ms sql server?
