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

How global temporary tables are represented and its scope?

977

When we should use @@error?

970

How to modify an existing stored procedure in ms sql server?

1080

Explain primary key?

969

What are data resources?

913

What are the reporting services components?

142

What is cdc in sql server?

1001

Distinguish between nested subquery and correlated subquery?

1045

Name some of the open source software that you can use in alternative to SSR?

161

What is an identity column in insert statements?

1023

How do I partition a table in sql server?

1042

how to overcome kernel isssues

1626

What is raid and what are different types of raid levels?

1152

How and why use sql server?

1010

What is a cube? : sql server analysis services, ssas

1000