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

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

862

What are subqueries in sql server? Explain its properties.

965

How to move database physical files in ms sql server?

956

What is cursor in ms sql server?

1090

What are the differences between clustered and non-clustered index?

954

What is tablesample?

1027

How to list all objects in a given schema?

985

Do you know what is rank function?

1029

what's new in sql server 2016?

906

What is filter index?

908

what's the maximum size of a row? : Sql server database administration

1012

Tell me what is a linked server?

987

How to connect of datebase with sql express.?

1050

How to truncate the log in sql server 2012? : sql server database administration

1199

what are the new features introduced in sql server 2000? : Sql server database administration

871