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
- 12620 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / jey ganesh
select min(sal) from employee where sal in(
select top 3 sal from employee order by sal desc)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can we use where clause with group by?
Explain about Joins?
How do I get to sql server configuration manager?
Does the order of columns in update statements matter?
How sql server enhances scalability of the database system?
What do you understand by recursive stored procedure?
Who is the owner of a schema in ms sql server?
What is exclusive locks?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What are some of the pros and cons of not dropping the sql server builtinadministrators group? : sql server security
How to encrypt Strored Procedure in SQL SERVER?
What are the different acid properties?
What is normalization according to you and explain its different levels?
What is cdc in sql server?
How to perform key word search in tables?
