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
58864 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 is for xml in sql server?

977

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1086

What is mean by candidate key?

945

How do you create a clustered index?

997

Explain stored procedure?

981

Difference between 2NF &3NF ?

1029

Is a primary key unique?

937

How to create new table with "create table" statements?

993

How to verify a user name with sqlcmd tool?

1019

application server is slow what may be the problem

2164

What is the use of “join” in sql server?

1017

Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

1004

Explain what is lock escalation and what is its purpose?

873

Explain external key management in sql server 2008

846

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1322