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 second highest salary?

Question Posted / subash

Answer Posted / subash

select sal from emp e
where 2=(select count(distinct sal) from emp b where
b.sal>e.sal)

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between translate and replace in oracle?

1116

what is IDE,DMV in sql server?

2755

How to compare dates in oracle sql?

1045

What is a cursor in oracle?

1109

Is insert autocommit in oracle?

1019

What is an oracle database table?

962

What are the original export and import utilities?

1059

How to drop a stored procedure in oracle?

1001

Why is oracle database so popular?

949

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1864

How many categories of data types in oracle?

963

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4116

What happens in oracle commit?

973

What are the different types of failures that occur in Oracle database?

1016

How to resolve the ORA-39133 error in Oracle?

1036