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 / sudhakar tripathi

select Max(salary) "2nd_Heigh_sal" from employees where
(salary < select Max(salary) from employees);

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database sql?

988


How do I view tables in mysql?

917


What is a database? Explain

1053


What is PL/SQL Records?

1116


What is error ora-01000: maximum open cursors exceeded

1065


what are the security recommendations while using mysql? : Sql dba

1051


What is sp_helptext?

1005


what is a cursor? : Sql dba

973


What is the difference between explicit and implicit cursors in oracle?

999


What are crud methods?

971


What is sql injection vulnerability?

872


What is the maximum rows in csv?

860


what is user defined functions? : Sql dba

977


Can you sum a count in sql?

956


what is try_catch block in procedure

1659