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...

query to retrive the employees whose sal is greater than avg
sal

Answer Posted / gop

SELECT sal FROM EMPLOYEES WHERE sal>(SELECT avg(sal) FROM
EMPLOYEES);

Is This Answer Correct ?    47 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does count (*) mean in sql?

1595


What port does sql server use?

1070


what are the advantages a stored procedure? : Sql dba

984


What is t sql used for?

1020


Is primary key is clustered index?

1006


Can a primary key be a foreign key?

1030


Can you rollback after commit?

995


Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2031


Does view store data in sql?

971


What is scalar function?

1058


What is difference between mysql and postgresql?

1164


what is oracle database ? : Sql dba

1038


Is sql microsoft?

1062


Does inner join remove duplicates?

948


Which operator is used in query for pattern matching?

1095