select count(*) as no_of_vehical,owner from MulBike group by owner having c

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 / gaurav.verma4210

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

Answer Posted / gaurav.verma4210

select count(*) as no_of_vehical,owner from MulBike group by owner having count(*)>=1

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do you know what is difference between index seek vs. Index scan?

960

Relational calculus is what type of language?

1049

How to create indexed view?

1056

How many types of subqueries are there in sql server?

1000

what exactly sql injuction.how to overcome.....

2555

Which autogrowth database setting is good?

1071

can a database be shrunk with users active? : Sql server administration

1022

Tell me about the approaches which you used to counter the DI problems.

1361

What is difference between after and before?

1105

What are the steps you must follow to hide sql server instances?

989

What is full outer join in sql server joins?

1076

can you implement data mining in SSRS?

151

Explain user defined views?

976

What is query cost in sql server?

1006

What command is used to rename the database?

1024