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 get second highest sal of emp table

Answer Posted / yadunandan

select max(sal) from emp where sal<(select max(sal) from
emp)

Is This Answer Correct ?    5 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an oracle user account?

990


what is a Nested Loop join?

2110


What is the difference between substr & instr functions?

1225


Can multiple cursors being opened at the same time?

1060


How to see the table columns used in an index?

1024


What is the difference between pre-select and pre-query?

1215


How many types of synonyms in Oracle?

1121


1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1970


What is the sql query to concatenate column values from multiple rows in oracle?

1054


How to calculate date and time differences in oracle?

1040


Point out the difference between user tables and data dictionary?

981


What is backup in Oracle?

1002


What is meant by a deadlock situation?

1109


What is not equal to in oracle?

996


How to resolve the ORA-39133 error in Oracle?

1112