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
- 51195 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 do you mean by cardinality?
what does the automatic recovery do? : Sql server administration
Is sql server a database?
What are information schema views?
How to provide login information for a new odbc dsn?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What are different types of statement?
What is a hint?
Explain about extended stored procedure?
How to include text values in sql statements?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Mention the different types of replication in sql server.
What is the difference between clustered index and primary key?
How to create an identity column?
