Select owner from table where bike in(‘pulsar’,’Honda’) group by o

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 / valibasha

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

Answer Posted / valibasha

Select owner from table where bike in(‘pulsar’,’Honda’) group by owner having count(*)>=1

Is This Answer Correct ?

7 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is a primary key unique?

941

Explain in brief how sql server enhances scalability of the database system?

937

what types of replication are supported in sql server? : Sql server database administration

959

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

932

What is the exact numeric data type in sql?

962

How many categories of functions based their return modes?

1063

Explain different types of lock modes in sql server 2000?

885

Why I can not enter 0.001 second in date and time literals in ms sql server?

1013

Is INSTEAD OF trigger directly applicable to Table ?

960

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1089

What are the differences between left join and inner join in sql server?

1042

Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?

128

what happens on checkpoint? : Sql server database administration

1021

Explain about the command-line tool SQLCMD?

1019

What is the difference between mysql and sql server?

943