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

Explain steps of normalization?

944


What is nolock hint in sql server 2008

1078


How to delete duplicate rows in sql server?

1058


What is the purpose of object explorer and its features? : sql server management studio

1124


What is subquery explain with example?

1010


What are the three different part of rdl file explain them?

253


What are various ways to enhance the ssrs report?

923


Tell me when is the update_statistics command used?

1021


Define Wed Edition in SQL Azure?

100


Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

1015


Define cursor locking

948


How to select all columns of all rows from a table with a select statement in ms sql server?

1046


What are the types of joins in sql?

1059


what are the critical issues you have resloved in your company

1921


How can a database be repaired?

925