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 the third highest salary?

Answer Posted / anu

select *
FROM (select emp1.* ,rownum rnum
     from ( select *  from emp order by sal_amount desc ) emp1
     where rownum<=3) 
where rnum >=3   

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the working of primary key?

1038


What is substitution variable?

1003


What will you get by the cursor attribute sql%found?

901


What are different types of indexes?

960


What is a recursive join sql?

1027


How to read/write files from pl/sql?

994


How to add a column ‘salary’ to a table employee_details?

955


Enlist the data types that can be used in pl/sql?

1013


How many types of cursors are available in pl/sql?

1045


What are properties of the transaction?

958


What are dml commands?

943


How sql query is executed?

1069


what are the different type of sql's statements ? : Sql dba

874


What is sql basics?

992


How are sql commands classified?

1038