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

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

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is sql exception?

966


what is data manipulation language? : Sql dba

1012


What is the difference between jpql and sql?

1092


Difference between table function and pipelined function?

1017


what is sql in mysql? : Sql dba

1185


What are the benefits of triggers?

1166


Why do we use view in sql?

948


how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1187


How do you write a complex sql query?

1061


Is merge a dml statement?

976


What is the difference between the conventional and direct path loader? : aql loader

1152


Which constraints we can use while creating database in sql?

1077


Is sql pronounced sequel or sql?

1260


What is sql integrity?

1148


What is pl/sql language case sensitive?

1110