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 are operators in oracle?

1053

What is a private synonym?

1585

How can we find out the current date and time in oracle?

1088

How to view the data files in the current database?

1095

Which is better Oracle or MS SQL? Why?

6382

What is the relation of a user account and a schema?

1130

Why is oracle used?

936

When system tablespace is created?

1036

How to write date and time interval literals in oracle?

1030

What is control file used for?

1200

what is the difference between restoring and recovering?

1009

What is oracle open database communication (odbc)?

1026

How to put more than 1000 values into an oracle in clause?

1029

How to drop a stored procedure in oracle?

1051

What are the differences between number and binary_float in oracle?

1098