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
- 51211 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
What is an execution plan?
What is a rollup clause?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is the maximum size of a row in sql server?
what is dbcc? : Sql server database administration
What happens if strings are casted into wrong code pages in ms sql server?
What is the difference between join and inner join?
Where are stored procedures in sql server?
How to view the error log for any specific instance? : sql server database administration
Explain having clause and where clause?
What is updatable resultset?
How can windows applications connect to sql servers via odbc?
What is scalar user-defined function?
What is the use of nvl work?
How to display a past time in days, hours and minutes?
