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 / sreenadh reddy

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

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 left join example?

891


how do you control the max size of a heap table? : Sql dba

924


What are the two different parts of the pl/sql packages?

1025


Does truncate require commit?

921


What is the size of partition table?

992


What is the difference between inner join and natural join?

956


What is a sql trace file?

978


What is sql character function?

996


What is offset in sql query?

1073


What does an inner join do?

1092


What trigger means?

929


What is delimiter sql?

924


What is percent sign in sql?

1214


explain the difference between bool, tinyint and bit. : Sql dba

939


what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

933