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

What are sub-queries? Give example? In which case
sub-queries are not feasible?

Answer Posted / bernatshaw

Sub-query means a Query within a Query.
This is the Example:
Select Employee_Id, Employee_name From Employees Where
Employee_Id IN (Select Mgr_Id from Manager)

Is This Answer Correct ?    12 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration

913


What is attribute relationships, why we need it? : sql server analysis services, ssas

973


What are the steps you will take to improve the performance of a poor performing query?

981


Explain about Normalization?

1069


Benefits of Stored Procedures?

982


What is SQL Azure Firewall?

136


What does the on delete cascade option do?

1019


What is tabulation?

956


Mention what are the different types of ssrs reports?

152


Explain what is log shipping?

1141


IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

1808


How to loop through result set objects using odbc_fetch_row()?

984


What is report server project?

149


What are the different types of backups avaialabe in sql server 2005?

1022


Where sql server user names and passwords are stored in sql server? : sql server database administration

1062