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
- 13454 Views
- I also Faced
- E-Mail Answers
Answer Posted / gajendra
select * from (select *,row_number()over (order by salary
asc)as a from Employee)as b where b.a=4
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
what is blocking? : Sql server database administration
How to include text values in sql statements?
Why it is recommended to avoid referencing a floating point column in the where clause?
How do I find the size of a sql server database?
What are the different editions available in sql server 2000?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
What are the disadvantages of merge replication?
How to modify existing triggers using "alter trigger"?
What is the difference between for trigger and after trigger?
Explain system rowset functions?
How to create and drop temp table in sql server?
How does normalization work?
What are the types of database recovery models?
How to insert data with null values?
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
