select ownername,count(bike) noofbikes from abikes group by ownername havin

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

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

Answer Posted / anil

select ownername,count(bike) noofbikes from abikes group by ownername having Count(bike)>1

Is This Answer Correct ?

4 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the new features of sql server 2008 r2 reporting service?

212

What is the meaning of resultset type_scroll_insensitive?

992

What is acid mean in sql server?

1198

Explain temporary table vs table variable by using cursor alternative?

1053

What are different types of join?

1375

plss anybody specify tha constrian management system in dbms

2205

Tell me extended events in sql server 2008?

1053

Explain how to send email from sql database?

1106

Why I have to use stored procedures?

1095

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

1051

What are sql azure firewall rules?

106

What is difference between clustered and non clustered index?

1034

What is the xml datatype?

1122

Is sql server difficult to learn?

968

What is ems sql management studio? : sql server management studio

1166