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 / jitendra kumar

select salary from (select salary from emp ordery by salary
(dese) where rownum>=2;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How sql query is executed?

1188


Is sql easier than java?

1069


What is pl sql in oracle?

1099


What is the file extension for sql database?

1066


What is a heap in sql?

1148


What are hotfixes and patches?

987


Is oracle sql free?

1039


Does mysql support pl sql?

1233


What does over partition by mean in sql?

1045


What are sql indexes?

1047


What is the sql case statement?

1055


Why use subqueries instead of joins?

1138


What are the types of optimization?

1009


Why primary key is required?

1046


what is the difference between myisam static and myisam dynamic? : Sql dba

1115