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

what is transaction? : Sql dba

1008


Is it possible to create startup or shutdown trigger for on-schema?

1029


how to enter binary numbers in sql statements? : Sql dba

974


Are left and right joins the same?

1088


What is nvl?

1065


explain commit and rollback in mysql : sql dba

1020


Why stored procedure is faster than query?

1062


Can you select everything, but 1 or 2 fields, without writer's cramp?

984


What has stored procedures in sql?

1066


What mean sql?

1014


What is the usage of nvl function?

1040


Which function is used to return remainder in a division operator in sql?

1141


What are the types of functions in sql?

1020


What is pl sql record in oracle?

1035


Name the operator which is used in the query for pattern matching?

954