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
- 13288 Views
- I also Faced
- E-Mail Answers
Answer Posted / veeresh kethari
with SalCTE (EMPID,Ename,Sal,Num)as
(select *,row_number() over(order by sal desc) num from emp)
select * from SalCTE where Num=4
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How to rebuild the master database?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What are the restrictions applicable while creating views? : SQL Server Architecture
What is cursors? And what are the different types of cursor?
Explain collation?
Explain the creation and execution of a user-defined function in the sql server?
Can sub report data source be different from that of the parent report?
What is sql injection and why is it a problem? : sql server security
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How do I find the sql server database version?
What is the usage of sign function?
What are the purpose of Normalisation?
Explain different types of Normalization.
What is a domain constraint give an example?
