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

write a query for list of owner who are having multiple
bikes in below table
1 shanker pulsar
2 shanker Honda
3 shanker car
4 Balu pulsar
5 Balu Honda
6 Balu car
7 Shyam pulsar
8 Jaya Honda
9 Deepa car
10 vasu car

Answer Posted / uttam sing rawat

select distinct Owner_Name from dbo.Tbl_Owner where bike
in(Select distinct bike from dbo.Tbl_Owner)

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to compare the top two records using sql?

1411


How many joins in sql server?

1004


What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

1029


What is partitioned view?

960


Explain comment on transactions?

1041


how would you improve etl (extract, transform, load) throughput?

1074


Can coalesce return null?

1068


How to identify current user in ssrs report?

408


What are locks in sql?

1014


What are the different types of upgrades that can be performed in sql server?

1213


What are key, name and value columns of an attribute? : sql server analysis services, ssas

1066


What are the extra roles available in msdb? : sql server security

1178


How to rebuild master databse?

1127


How to provide values to user defined function parameters?

1061


How to receive output values from stored procedures?

1231