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 / sanjay

select top 1 EmployeeID,min(Rate ) from
(select top 2 EmployeeID ,Rate from
EmployeePay
order by Rate desc)table1 group by EmployeeID ,Rate

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between convert.tostring and i.tostring method?

930


Tell me which namespace are used for accessing the data?

926


What is misl code?

994


What does assert() method do In VB.NET

933


Is vb net a scripting language?

919


What are the assembly entry points?

966


What is late binding?

901


Explain nested classes?

912


Observations between vb.net and vc#.net?

1001


what is common language specification?

923


How do you call a stored procedure in Visual Basic?

1067


Write a program that would find the nth term of a geometric progression, given the value of first term and common ratio. Any inbuilt function that the language provides for calculating exponent should not be used.

3488


How many classes a dll can contain?

944


What are the features present in vb 2005?

980


Explain the differences between vb.net and c#, related to oops concepts?

891