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

how to find the second highest salary from emp table?

Answer Posted / moharaj m

select max(salary) from emp where salary < (select max
(salary) from emp)

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 type and rowtype in pl sql?

1020


Is oracle sql free?

991


What is sql and its types?

1192


What is the reports view in oracle sql developer?

997


In pl/sql, what is bulk binding, and when/how would it help performance?

995


what is a unique key ? : Sql dba

1096


How many sql statements are used? Define them.

1043


How do I pipe the output of one isql to another?

1007


What is the use of procedures?

975


How do sql databases work?

1003


How do I view output in sql developer?

1089


Can we insert data into view?

907


how can we know the number of days between two given dates using mysql? : Sql dba

1048


how to select unique records from a table? : Sql dba

1116


Is oracel sql developer written in java?

1114