SELECT MAX(VCRG_ID) FROM dbo.TRN_VEHICLE_CARGO WHERE VCRG

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

Question Posted / prafulla borade

35 Answers
60166 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

Please Help Members By Posting Answers For Below Questions

Explain transaction server isolation?

1041

What are data files?

1039

Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2747

What is a mixed extent?

1021

What is openxml in sql server?

1168

What is entity data services?

1064

Why do we use non clustered index?

1081

What are the new features of sql server 2008 r2 reporting service?

209

Show Practically Sql Server Views are updatable?

1123

Determine when an index is appropriate?

1076

What are the types of stored procedures in an sql server?

989

What is difference between aggregate and analytic function?

929

What are the purposes of floor and sign functions?

976

How do I make a resultset scrollable?

958

How to create new tables with "create table" statements in ms sql server?

1066