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

how to find the n'th highest salary from emp ?

Question Posted / sunil panghal

Answer Posted / sunil panghal

select salary from emp where salary=(select max(salary)
from emp)

Is This Answer Correct ?    6 Yes 23 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is recovery manager(rman) backup in Oracle?

1187

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?

2081

What is oracle database 10g express edition?

1123

When do you get a .pll extension in oracle? Explain its importance

1044

Define oracle database

1049

Can we write insert statement in function in oracle?

1096

What is the usage of analyze command in oracle?

1096

What is a dead lock in oracle?

1129

What is truncate oracle?

977

What is varray?

1146

How to view the tablespaces in the current database?

985

What is snapshot is too old? Give and example for better understand.

1607

Can multiple columns be used in group by in oracle?

990

How to manage transaction isolation level?

1009

What is the relationship among database, tablespace and data file?

993