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

What is molap and its advantage? : sql server analysis services, ssas

929

Write a query to find 5th highest amount paid from the customer table.

879

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

1199

What is normalization of database? What are its benefits?

960

Tell me what is de-normalization and what are some of the examples of it?

958

How to execute function in stored procedure sql server?

1045

Define a cross join?

953

Can you explain powershell included in sql server 2008?

890

What is a Join and explain its types?

1046

what is database replicaion? : Sql server database administration

1102

What is role playing dimension with two examples? : sql server analysis services, ssas

952

What is implicit mode in sql server?

1027

How many types of local tables are there in sql server?

886

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2320

what are database files and filegroups? : Sql server database administration

885