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 / sreenadh reddy

select max(sal) from emp where sal <(select max(sal) 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 are the join types in tsql? : Transact sql

1101


What is a pl/sql block?

1325


How do you concatenate in sql?

1086


What is sql used for?

1164


How can I delete duplicate rows?

1063


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

1056


What does pragma mean?

1130


How do I use google cloud in sql?

1144


What are views in sql?

1037


what are the different functions in sorting an array? : Sql dba

1065


What is basic structure of pl sql?

1129


What is sql scripting?

1191


What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1056


what happens if you no create privilege in a database? : Sql dba

1047


What does seeding a database mean?

1014