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
61239 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

Please differentiate between a local and a global temporary table?

1059

What is system stored procedures?

1083

Explain what are the authentication modes in sql server?

1071

Do you know the cursor types?

1205

What is the process of normalization?

1180

What is table valued function and scalar valued functions?

1161

Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?

1065

Can you always create a cache of a report?

178

What is difference between views and stored procedures?

1029

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

1175

What is the usage of the sign function?

1193

How is sql used in sql server?

1056

Explain about SQLOS?

1060

What are the disadvantages of primary key and foreign key in SQL?

1151

What are a scheduled jobs?

990