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 / chaitanya pathak

select max(salary) from employee
where salary<(select max(salary) from employee)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Whis is not false in primary key?

1526


What is use of package in pl sql?

1071


Is progress software supports to ( pl/sql )?

1099


How to use distinct and count in sql query? Explain

1086


How do you use a while loop in pl sql?

1056


How delete all records from table in sql?

1015


How to check if a column is nullable before setting to nullable?

1188


What are keys in sql?

1043


Why do you partition data?

1066


what is bdb (berkeleydb)? : Sql dba

1093


What is normalization sql?

1119


what is sql server agent? : Sql dba

1158


Explain the components of sql?

1108


Explain the difference between triggers and constraints?

1025


What is difference between sql and oracle?

1192