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 / chaitanya pathak

Answer Posted / chaitanya pathak

select max(salary) from employee
whrere salary<(selsect max(salary) from employee)

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to create a new user account in oracle?

1021

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

What is a system tablespace and when it is created?

972

Is oracle a programming language?

990

Explain oracle’s system global area (sga).

1139

How to define a record variable to store a table row?

1058

How to fetch the row which has the max value for a column?

1002

What are the types of partitions in oracle?

1038

What is ASM (Automatic Storage Management) in Oracle?

1197

In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1842

How to rename an index?

1073

What are the oracle built-in data types?

1074

How do I find my oracle client driver version?

1040

What is the difference between formal parameters and actual parameters?

1089

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.

2180