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

select max(sal) from table_name sal<(select max(sal)
from table_name)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are different functions in sql?

998


what is table? : Sql dba

1109


What are the 3 types of behavioral triggers?

1314


What is sqlca in powerbuilder?

1067


Which certification is best for sql?

1041


Difference between truncate, delete and drop commands?

1145


What is the difference between nested table and varray?

1052


How can we store rows in PL/SQL using array?

1270


What are user defined functions?

1067


what are the performance and scalability characteristics of mysql? : Sql dba

1034


How to avoid using cursors?

1179


What is java sql connection?

1121


What is package in pl sql with an examples?

1089


What is the difference between unique and primary key constraints?

1122


Why do we use procedures in pl sql?

1076