How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
- 35 Answers
- 55038 Views
- Oracle, Scend, TechInfini, I also Faced
- E-Mail Answers
Answer Posted / prafulla borade
SELECT MAX(VCRG_ID) FROM dbo.TRN_VEHICLE_CARGO WHERE VCRG_ID< (SELECT MAX (VCRG_ID) FROM dbo.TRN_VEHICLE_CARGO)
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Explain different backup plans?
What is cte (common table expression)?
Some queries related to SQL
Is candidate a key?
What kind of problems occurs if we do not implement proper locking strategy?
What is intellisense?
how you can deploy an ssrs report?
What is an expression in ms sql server?
Do you know what is difference between stored procedure and user defined function?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What are the different sql server versions?
what kind of lan types do you know? : Sql server database administration
What does it mean to normalize a database and why would you do it?
Can an entity have two primary keys?
Does the unique constraint create an index?
