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

How will you find out if there are expensive SQL statements running or not?

973

How do you handle datasets larger than 50 gb?

162

Explain what are the restrictions while creating batches in sql server?

1024

Define model database?

935

What are the restrictions applicable while creating views? : SQL Server Architecture

983

What is the parse query button used for?

982

What is BLOCK statements in SQL?

1208

What is the maximum size per database for sql server express?

975

explain different types of joins? : Sql server database administration

926

What is difference between group by and having?

912

What is the difference between a view and a stored procedure?

986

What is the main purpose of having conversation group?

849

What is the full meaning of dml?

908

What does normalization do to data?

995

Can we join two tables without primary key?

985