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...

find out the third highest salary?

Answer Posted / ashutosh pandey

select sal from emp
where sal=(select min(sal) from emp
where sal>(select min(sal) from emp
where sal>(select min(sal) from emp);

Is This Answer Correct ?    69 Yes 204 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to open a cursor variable?

975


How to count duplicated values in a column in oracle?

985


What are the execution control statements?

1018


What is oracle server autotrace in oracle?

1091


How do I reset a sequence in oracle?

1052


Explain what are the advantages of views?

1014


What is the meaning of recursive hints in oracle?

995


how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2506


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1618


How to handle a single quote in oracle sql?

975


How to install oracle odbc drivers?

1040


What is BBED in Oracle?

1091


What is the exact use of Collections?

2095


How to find the duplicate rows count from employees table in oracle?

1041


What is the use of aggregate functions in oracle?

981