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

Answer Posted / anand

SELECT SALARY FROM (SELECT SALARY FROM emp WHERE ROWNUM < 3
ORDER
BY salary) WHERE ROWNUM < 2

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2187

How to connect ms access to oracle servers?

1014

Explain temporal data types in oracle

1099

Can multiple columns be used in group by in oracle?

993

How does oracle handle read consistency?

1103

What is varray?

1146

What is a static data dictionary in oracle?

1121

How to insert a record into a table?

1076

How to shutdown your 10g xe server?

1155

What is the disadvantage of User defind function?

2302

What is concurrency in oracle?

1013

What are the major difference between truncate and delete?

1067

How to get a list of all user accounts in the database?

1090

What is BBED in Oracle?

1165

What happens if the update subquery returns multiple rows?

1124