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...

find the second highest salary of the emp table

Answer Posted / guest

ANS:
select max(salary) from Employees
where salary not in
(select max(salary) from Employees )

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the scope of a local variable?

998


How to execute the package in oracle?

1039


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3275


How do I call oracle stored procedures that take no parameters?

1025


Explain oracle’s system global area (sga).

1076


How do I limit the number of oracle database connections generated by weblogic server?

1008


How to calculate date and time differences in oracle?

994


How many categories of data types?

940


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

969


What are dml statements in oracle?

1045


How to create a new view in oracle?

1015


What is an oracle tablespace?

985


Explain an integrity constrains?

1085


What is the difference between I and G in Oracle?

1023


What is blob data type in oracle?

1049