Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

sql satement for 2nd maximum value

Answer Posted / suresh

department as table name,sfee as column name
SELECT TOP (1) sfee
FROM DEPARTMENT
WHERE (SFEE IN
(SELECT TOP (2) SFEE
FROM DEPARTMENT AS
DEPARTMENT_1
ORDER BY SFEE DESC))

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain convert.tostrin?

1061


What is different between web.config and machine.config and where it will be ?

1021


what is common language specification?

977


Name the two main parts of .net?

945


Explain the observations between vb.net and vc#.net?

935


Describe about visual basic.net?

1000


What is early binding?

950


What is difference between import system.data.sqlclient,system.data.oledb?

1030


how many server control present in .net

2763


What is the purpose of objects present in asp.net?

1051


What are the differences between server-side and client-side code?

1042


What are the advantages of migrating to vb.net?

991


Explain enumerator?

921


Explain the difference between .dll extension and .exe extension files?

1059


difference between control and component more than one differences

3049