Interested to Buy Any Domain ? << Click Here >> for more details...
select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal.
- 8 Answers
- 12637 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / sunil nair
SELECT EmpID,Salary from tblSalary a where 3=(select count
(EmpID) from tblSalary b where b.empid=a.empid)
for any RDBMS
| Is This Answer Correct ? | 2 Yes | 13 No |
Post New Answer View All Answers
Explain the steps to create and execute a user-defined function in the sql server?
Can I delete event logs?
What Are the Main Features of SQL Azure?
Do you know exporting and importing utility?
What is a print index?
Explain what are commit and rollback in sql?
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
Define outer join?
Why do we use stored procedures in sql server?
How to make conditional sum in ssrs?
Can you explain about buffer cash and log cache in sql server?
Write down the syntax and an example for create, rename and delete index?
How to change the name of a database user?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
Introduction of rollup clause using sum and group by clause?
