select Owner from dbo.[table] where Bike in (select bike from dbo.[table])

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

Question Posted / gangadharrao

12 Answers
15368 Views
Cognizant, TCS, I also Faced
E-Mail Answers

Answer Posted / gangadharrao

select Owner from dbo.[table] where Bike in (select bike
from dbo.[table]) group by owner having count(*) >1

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 tablesample?

1030

your distribution database is full what will u do

2129

Explain the difference between delete,drop and truncate in SQL Server?

1022

What are functions in the sql server?

1128

Can you tell me about the concept of ER diagrams?

1018

Can the “if update (colname)” statement be used in a delete trigger?

946

Explain partitioned view?

1023

Explain about integration services of Microsoft SQL server?

984

What are “phantom rows”?

1609

How do I create a stored procedure in sql server?

965

How to delete multiple rows with one delete statement in ms sql server?

943

What is a constant or literal in ms sql server?

995

What are the default system databases in sql server 2000?

964

What stored procedure can you use to display the current processes?

839

Explain what is the main purpose of having conversation group?

882