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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

find out the third highest salary?

Question Posted / naveen kumar

Answer Posted / naveen kumar

Hi everybody,
This is one way to get the third highest salary
select ROWNUM as RANK from (select * from emp order by sal)
where ROWNUM<=3

Is This Answer Correct ?    11 Yes 27 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the components of logical database structure in oracle database?

1136

What is raw datatype in oracle?

1210

How to create a single index for multiple columns?

1080

Explain constraining triggers.

1163

What privilege is needed for a user to delete rows from tables in another schema?

1133

What is connection pooling in oracle?

1018

What is data file?

1149

Is oracle a programming language?

1037

How to resolve name conflicts between variables and columns?

1078

Difference between inner join vs where ?

1096

How can I see all tables in oracle?

1060

How to bring a tablespace offline?

1113

How to view the tablespaces in the current database?

1026

What is the purpose of tables, private synonyms and public synonyms in Oracle?

1092

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2143