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 / amrish singh

Answer Posted / amrish singh

this is the query for retrieving nth highest salary from
table emp
select e.sal
from emp e
where n-1=(select count(*) from emp s where s.sal>e.sal)

putting the value of n we get the required result.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to handle a single quote in oracle sql?

1099

How to install oracle database 10g xe?

1064

What is the use of oracle?

1078

How to view the data files in the current database?

1151

What is the difference between Delete, Truncate and Drop in Oracle?

1185

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

1100

what are the default admin accounts in Oracle 10g ?

1024

Describe an oracle table?

1100

Explain the use of consistent option in exp command.

1142

What is the max number of columns in an oracle table?

1048

Explain oracle instance.

1234

How to concatenate two text values in oracle?

1159

What is oracle in java?

1019

What is oracle datasource?

1041

defination of bitmap index

2180