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 / prithvi

Answer Posted / prithvi

select Max(sal) from emp

This will give us 1highest sal

Select Max (sal) from where sal <(select Max(sal) from emp)

Select Max (sal) from where sal <(Select Max (sal) from
where sal <(select Max(sal) from emp))

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you identify oracle database software release?

1058

What is the difference between sharding and partitioning?

1039

How to convert times to characters in oracle?

1071

How do I connect to oracle database?

1198

What is recovery manager in Oracle?

1109

How to select all columns of all rows from a table in oracle?

1097

What do you know about normalization? Explain in detail?

1002

How to define a sub function?

1200

Please explain oracle left join with an example?

1095

What are the attributes of the cursor?

1058

What is a dynamic performance view in oracle?

1058

How to test null values?

1156

How to count groups returned with the group by clause in oracle?

1122

How to recover a dropped table in oracle?

1094

How many data types are supported?

1137