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
- 59277 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
What is the difference between createstatement and preparedstatement?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is the difference between a function and a stored procedure?
What command do we use to rename a database?
How to delete duplicate rows from table except one?
What do you mean by cardinality?
What is an expensive query?
How to convert numeric expression data types by assignment operations?
What is the purpose of forms?
What do you mean by authentication modes in sql server?
Distinguish between commit and rollback?
What are transactions in sql?
Which data type columns are the best candidates for full-text indexing?
where can you add custom error messages to sql server? : Sql server administration
What is the command to change the recovery model?
