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

How you trouble shoot when any job fails

1984

How do you rename a table in sql server?

1104

What is transaction server consistency?

1109

What is log in sql server?

1207

What do you mean by an execution plan? Why is it used?

1083

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1122

Can we call stored procedure in trigger?

999

How to add a new column to an existing table with "alter table ... Add" in ms sql server?

1054

What is a non equi join?

1026

How the authentication mode can be changed?

1176

Explain the usage of floor function in sql server.

1027

What is difference between count (*) and count 1?

978

It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio

1090

What is database black box testing?

1076

What are various ways to enhance the ssrs report?

1037