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 / anirban mitra

Answer Posted / anirban mitra

SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN (SELECT MAX(SAL)
FROM EMP UNION SELECT MAX(SAL) FROM EMP WHERE SAL NOT IN
(SELECT MAX(SAL) FROM EMP))

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is clustered table in Oracle?

1108

How can I create database in oracle?

961

What is hash cluster in oracle?

1091

How to use select statement to count the number of rows in oracle?

991

How to convert times to characters in oracle?

979

What are the attributes of cursor?

990

What happens if variable names collide with table/column names?

1105

Calculate difference between 2 date / times in oracle sql?

987

How to get execution statistics reports on query statements?

1009

How a database is related to tablespaces?

987

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1957

what is Single Byte Overhead...?

2500

How to view the data files in the current database?

1045

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

993

Hi Can any one tell me what are the API's used in requisition import.

1881