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

What are the objects in asp.net?

1087


How do you retrieve the customized properties of a .net application from xml .config file?

933


What are jagged arrarys ?

937


Explain about rapid application development tool?

911


How do you script this scenario in QTP using VB? Verify XML attributes in XML message against XSD and data mapping of fields to Oracle tables? Verify data in XML to data in a defined table?

2927


What is difference between metadata and manifest?

1047


What is meant by jagged arrays?

995


Explain internal keyword in .net framework?

944


Explain the advantage of option strict on?

890


What’s the difference between private and shared assembly?

1087


What is private assembly?

904


What is the importance of a Button control?

1279


List the types of authentication?

880


Tell me which namespace are used for accessing the data?

951


Explain nested classes?

924