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 highest salary from emp table?

Answer Posted / sarojkant

select max(salary ) from emp table where sal<(select max
(salary)from emp table)

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 plv (pl/vision) package offers?

981


What makes a good primary key?

981


What are tables in sql?

999


what are all types of user defined functions? : Sql dba

998


Why select is used in sql?

969


What is the starting oracle error number? What is meant by forward declaration in functions?

940


Is like operator in sql case sensitive?

962


Give the order of sql select?

1089


what is normalization? : Sql dba

1018


define join and explain different type of joins? : Sql dba

900


What is data control language (dcl)?

1047


How run sql*plus commands that are stored in a local file?

976


What is sqlexception in java?

941


What are tables and fields in the database?

1025


what is single byte over head in oracle..?

2342