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
- 13250 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
what is spatial nonclustered index
how would you store your query in an SSRS report or a Database server?
What is de-normalization and what are some of the examples of it?
How network traffic be reduced by using the stored procedure?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
How optimize sql query with multiple joins in sql server?
What are the different index configurations a table can have?
Why should we go for stored procedures? Why not direct queries?
Tell about MOM Tool(Microsoft Operator Manager)?
Why use “pivot” in sql server?
Define left outer join in sql server joins?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
Do you know the cursor types?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
What is the importance of a recovery model?
