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

explain the delete statements in sql

1075


what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

982


How much does sqlite cost?

1051


Define overloaded procedure?

1090


Why do we use partitions in sql?

1057


Explain the update statement in sql

1006


What do you mean by query optimization?

1010


How many row comparison operators are used while working with a subquery?

1040


Why we use triggers in mysql?

997


What is not null in sql?

1064


How do I sort a table in sql?

1053


How many types of index are there?

1048


Is left join same as join?

1003


differentiate between float and double. : Sql dba

1065


Does access use sql?

1049