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

Where do you use decode and case statements?

945


What are the predefined tablespaces in a database?

1011


What is java oracle used for?

973


How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2203


What are the parameters that we can pass through a stored procedure?

1000


How to select an oracle system id (sid)?

1020


interview questions with answer for cts

2534


How to create an initialization parameter file?

985


what is the scripts in data base?

2080


What is the difference between substr & instr functions?

1124


How to create an oracle database?

978


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

2134


What is a nested table and how is it different from a normal table?

988


What is meant by joins? List out the types of joins.

960


How to change system global area (sga) in oracle?

960