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

select Max(salary) from test where salary not in(select Max
(salary) from test);

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of %rowtype?

1086


Explain the advantages and disadvantages of stored procedure?

1198


What are triggers in sql?

1061


What is the difference between a query and a report?

1055


who introduced sql?

1074


Sql technical questions

1334


What is the use of primary key?

1049


What are the advantages of pl sql?

1166


what are the features and advantages of object-oriented programming? : Sql dba

1072


what does the t-sql command ident_current does? : Transact sql

1048


what is 'mysqladmin' in mysql? : Sql dba

1073


What is user in sql?

1076


explain the difference between bool, tinyint and bit. : Sql dba

1063


What is t-sql? : Transact sql

1041


what are different types of collation sensitivity? : Sql dba

1118