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
- 13223 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 many triggers you can have on a table?
Explain mixed authentication mode of sql server?
What do you mean by recursive stored procedure?
What is use of attribute hierarchy optimized state? : sql server analysis services, ssas
What is cursors? And what are the different types of cursor?
What is the index requirement in SQL Azure?
How check triggers in sql server?
What is sub-query in sql server? Explain its properties.
How to turn off warning messages during php execution?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How to use go command in "sqlcmd"?
How can a user-defined datatype be created?
Give main differences between "Truncate" and "Delete".
can we have a nested transaction? : Sql server database administration
What does it mean to normalize data?
