what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
- 7 Answers
- 8571 Views
- I also Faced
- E-Mail Answers
Answer Posted / veeresh kethari
with Topsal (EmpID,Ename,Sal,Dno,Topsal) as
(select *,row_number() over(order by sal) Topsal from emp)
select top 2 EmpID,Ename,Sal,Dno from Topsal order by sal desc
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain filestream storage of sql server 2008?
Explain isolation levels that sql server supports?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What is SQL Azure Data sync?
What is inline variable assignment?
What are trace files?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
When we should use @@error?
What is difference between group by and having?
What do you understand by intent locks?
Can you please explain the difference between primary keys and foreign keys?
List some of the rules that apply to creating and using a ‘view’
What stored by the model? : sql server database administration
What is an indexed view?
How to create view in stored procedure sql server?
