Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
Answer Posted / v rajkumar
select salary from Emp a where 4 = (select count(distinct
(salary)) from Emp b where b.salary>= a.salary)
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What are different replication agents and what's their purpose? : sql server replication
What is log ldf?
What stored by the msdb?
Which tcl commands are available on the sql server?
what is blocking? : Sql server database administration
Can You Use Data Mining Models In Ssrs?
How is foreign key related to primary key?
What does dml stand for?
What is a view and what are its advantages?
Where sql server user names and passwords are stored in sql server? : sql server database administration
Why do you want to join software field as you have done your BE in Electronics?
Explain the difference between delete,drop and truncate in SQL Server?
What is trigger explain with program?
Explain about unique identifier data type in sql server?
What is the need for indexing?