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
- 12345 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
How do database indexes work?
What different steps will a sql server developer take to secure sql server?
How to test values returned by a subquery with the in operator?
What is the difference between insensitive and scroll cursor?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is the simplest way to create a new database in ms sql server?
What is the full meaning of dml?
Can two different columns be merged into single column? Show practically?
how you can get the list of largest tables in a database? : Sql server administration
Can you force a query to use a specific index?
What program is used to store the data source file?
‘Order by’ is not allowed in a view how can you sort information from a view?
What is conditional split?
How you would rewrite the sql query to return the customerid sorted numerically?
