Interested to Buy Any Domain ? << Click Here >> for more details...
Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 13245 Views
- I also Faced
- E-Mail Answers
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 is normalization? : Sql server database administration
How to create prepared statements using odbc_prepare()?
What is temporal table?
Explain can SSRS reports Cache results?
How to create user messages with print statements in ms sql server?
what do you understand by change data capture?
How ssrs maintain security?
How to create an inline table-valued function?
How to create percentile function?
What is the contrast between sql and pl/sql?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is a rownum?
How to list all user defined functions in the current database?
What is the command used to check locks in microsoft sql server?
What are the types of database schema? : sql server analysis services, ssas
