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

select salary from table_name where salary <(select salary
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

Why do we need a foreign key?

1091


What is embedded sql in db2?

1013


what is isam? : Sql dba

1003


Explain the purpose of %type and %rowtype data types with the example?

989


what tools available for managing mysql server? : Sql dba

1078


What is meaning of <> in sql?

1067


What is the purpose of the partition table?

1049


How to run sql*plus commands in sql developer?

1151


Why do we use sql constraints?

1166


Does oracle roll back the transaction on an error?

1013


Why primary key is required?

1003


What are the different types of joins in sql?

1781


What is difference between stored procedures and application procedures?

1011


How do I install microsoft sql?

1050


What are sql data types?

1020