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 calcuate the second highest salary of he employee

Answer Posted / udhayakumar

select salary from (select salary from emp order by salary
desc) where rownum=2;

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trigger explain with example?

982


give the syntax of grant and revoke commands? : Sql dba

1088


When should I use nosql database?

944


Are subqueries better than joins?

917


What are the 3 types of behavioral triggers?

1182


Is sql developer case sensitive?

944


How do I write a sql query in pgadmin 4?

924


What is rename in sql?

916


Why are sql stored procedures used?

987


what is the difference between a local and a global temporary table? : Sql dba

1004


what is the difference between $message and $$message? : Sql dba

944


How to get each name only once from an employee table?

1062


What is break?

1140


Is inner join faster than left join?

1124


Which one is better subquery or joins?

1008