Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed)
- 8 Answers
- 13636 Views
- I also Faced
- E-Mail Answers
Answer Posted / shashank tayal
select salary from table_name order by desc limit 3,1;
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is the difference between for xml raw and for xml auto?
Equi join and non equi join is possible with sql server?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
How do I find query history in sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What are the different SQL Server Versions you have worked on?
Why should you use or avoid select * statements?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
Why use identity in sql server?
What is subquery? Explain the properties of a subquery?
what is spatial nonclustered index
What is an indexed view?
Why we use the openxml clause?
Can we shrink data file in sql server?
