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

create table emp with row empsal having the datatype float
and insert some salary
now to get the second max salary
write the sql statement

select max(empsal) from emp where empsal<(select max(empsal)
from emp)
its asubquery

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the difference between dispose(), close(), exit(), end()? When do we use them?

983


How many classes a dll can contain?

944


What is non_deterministic finalization?

1033


How to create a constant in vb.net?

1101


What is DLL HELL in VB.NET

988


What does assert() method do In VB.NET

933


What are nested classes?

892


Can we use Vb.Net and C# language simultaneously in one .Net application?

954


Why do we use byref keyword in vb.net?

1000


What is redim keyword and its use?

958


How to execute VB.NET PROJECTS,VB6.0 PROJECTS AND write their test cases.Need Reply Urgently

2452


What is the difference between .dll extension and .exe extension files?

1040


Explain how the .net framework performs automatic memory management.

946


Write a program to find all text files in a logical drive and return the count of the number of files?

2662


Explain about delegate?

839