Interested to Buy Any Domain ? << Click Here >> for more details...
what is syntex second or third highest salary.
thanks & Regards
Dhirendra sinha
- 7 Answers
- 9851 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
Do comments need to go in a special place in sql server 2005?
In my application I have a process which picks the scanned files (tif format) from a shared location and it links to application and shown on it.The actuall issue is that my process picks the file before it is completly written or scanned which results in displaying few parts of the image or incomplete image.I need to check if the file is not completly scanned or written then do not link it to application.Please help if any body tell me that how can i check that file is in written phase or locked through DTS.thanking you in advance
How to perform backup for certificates in sql server? : sql server security
Do you know what is replace and stuff function in sql server?
What is table valued function and scalar valued functions?
What is difference between equi join and inner join?
What is policy based management (pbm)? : sql server database administration
Is a primary key unique?
What is replace and stuff function in sql server?
which backup strategy you are following at ur company
Can we insert data into a view?
Explain trigger and its types?
What you can do to delete a table without the delete trigger firing?
What is attribute hierarchy? : sql server analysis services, ssas
What is the difference between a function and a trigger?
