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

What are the differences between “row_number()”, “rank()” and “dense_rank()”?

1150

Â Explain what is sql override for a source taLle in a mapping?

1013

What are the ways available in sql server to execute sql statements?

1140

What are the grouping functions?

936

What are the tool windows in sql server management studio? : sql server management studio

1082

How to link tables in sql server?

938

Can you use order by when defining a view?

979

How check triggers in sql server?

997

What are the different SQL Server Versions you have worked on?

1007

Explain something about security and SQL Azure?

134

What is index in an assignment?

955

What are click through reports?

142

What is the purpose of forms?

960

What are joins in sql and what are the different types of joins?

1015

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1055