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...

how to find the second salary?

Answer Posted / kavitha

select max(salary) from tablename where salary not in(select
max(salary) from tablename )

or


select max(salary) from tablename where salary <(select
max(salary) from tablename )

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to change the system date and time from SQL Plus Terminal ?

1232


What will be the maximum number of index per table?

1013


What is 2nf example?

1002


explain different types of constraints? : Sql server database administration

962


Can sub report data source be different from that of the parent report?

144


List some advantages and disadvantages of stored procedure?

1019


what data regions are and what are the different data regions?

142


How do you create an execution plan?

958


What are orphan records?

940


What is an identity?

1023


Why are you getting errors when creating a new odbc dsn?

1232


What does truncate do?

946


Explain the disadvantages/limitation of the cursor?

967


How many primary keys are possible in a table?

931


What are various aggregate functions that are available?

996