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

select max(salary) from employee where salary!=(select max
(salary) from employee);

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How long will it take to learn pl sql?

946


How do you concatenate in sql?

1034


Are stored procedures compiled?

932


What is primary key and unique key?

1124


What is the usage of distinct keyword?

1070


What is sql exception?

980


Why are cursors used?

1124


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1166


explain advantages of innodb over myisam. : Sql dba

1135


What is type and rowtype in pl sql?

1022


What is the difference between syntax error and runtime error?

1148


when is the use of update_statistics command? : Sql dba

1058


what is data integrity? : Sql dba

1045


What is java sql drivermanager?

1104


What is $$ in sql?

1002