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
- 12328 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
How can I check that whether automatic statistic update is enabled or not?
Write a SQL query to make a column as unique?
what is a mixed extent? : Sql server administration
What is normalization? Explain its different types?
explain the storage models of olap? : Sql server database administration
What is the significance of master, tempdb and model databases?
How do you use a subquery to find records that exist in one table and do not exist in another?
Explain the truncate command? : SQL Server Architecture
Distinguish between nested subquery and correlated subquery?
How you can move data or databases between servers and databases in sql server?
Describe the functionalities that views support.
Name three of the features managed by the surface area configuration tool? : sql server security
Which tcl commands are available on the sql server?
How to execute function in stored procedure sql server?
What is 2nf in normalization?
