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

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

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 difference between local variables and global variables?

1123


Which column in the user.triggers data dictionary view shows that the trigger is a pl/sql trigger?

1036


What is the file extension for sql database?

997


what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1122


how many groups of data types? : Sql dba

1020


Is sql injection illegal?

1015


How global cursor can be declare with dynamic trigger ?

2206


what is heap table? : Sql dba

1103


Does asenumerable execute the query?

1038


How do I kill a query in postgresql?

1109


What is package in pl sql?

1013


explain advantages of innodb over myisam. : Sql dba

1126


what is top in tsql? : Transact sql

1113


Is sql between inclusive?

1121


Can we use join in subquery?

1087