select count(*) as no_of_vehical,owner_name from vehicles group by owner

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

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

Answer Posted / vidhya

select count(*) as no_of_vehical,owner_name from vehicles group by owner_name having count(*)>=1

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

According to you what goes into making the best database administrator? : sql server database administration

1022

What are the general features of sql server management studio? : sql server management studio

1133

How to create “dependant” parameter “make, model, year”

137

What is the process of normalization?

1180

What is buffer cash and log cache in sql server?

1186

What does this statement do @@rowcount?

1016

Explain a differential backup?

1060

What are the different types of lock modes in sql server 2000?

995

Explain syntax for viewing, dropping and disabling triggers?

996

What are various limitations of the views?

1090

What is open database communication (odbc)?

1115

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1115

How many types of attribute relationships are there? : sql server analysis services, ssas

1133

Define self join?

1078

What is snapshot report?

172