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 do you mean by serialization?

1004


What is static member?

1047


What is datatype conversion?

1202


What is the class that allows an element to be accessed using unique key?

1205


What would you do to remove microsoft visual basic name space?

1000


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

1051


What are the different variables in vb.net?

1009


What is the significance of delegates. Where should they be used?

999


Explain about jagged arrarys ?

951


Name and explain some of the exclusive features which are present in vb?

1002


Which properties are used to bind a DataGridView control?

1187


How would you implement inheritance using vb.net?

961


what is commom language runtime?

1009


Write the role of new keyword?

1196


How many ways the function can return values?

1065