Interested to Buy Any Domain ? << Click Here >> for more details...
what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
- 7 Answers
- 10039 Views
- I also Faced
- E-Mail Answers
Answer Posted / dipti saxena
select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=3
MINUS
select sal,rownum from (select sal from emp
order by sal desc)
where rownum<=1
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
What are the advantages of log shipping?
What is dbcc command in sql server?
What is in place upgrade in sql server?
How to use union to merge outputs from two queries together in ms sql server?
What are the three different part of rdl file explain them?
What are the advantages of passing name-value pairs as parameters?
How to test subquery results with the exists operator?
What is the difference between rank and dense_rank?
What is normalization of database? What are its benefits?
Why are views required in the sql server or in any other database?
Tell me what are the essential components of sql server service broker?
How to specify the collation for a character data type in ms sql server?
What is a functions and types in sql server?
when you create a database how is it stored? : Sql server database administration
