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
- 61270 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
Please differentiate between a local and a global temporary table?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
Which sql server table is used to hold the stored procedure scripts?
What is a partition function in sql server?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What is a subquery in a select query statement in ms sql server?
Explain Reporting Life Cycle?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
Explain indexing and what are the advantages of it?
Explain different types of collation sensitivity?
How to filter records of table in SQL SERVER?
What is the use of sql profiler in sql server 2012?
Which are the third-party tools used in sql server and why would you use them?
Explain about temporary stored procedure?
Explain how to use linked server?
