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
15780 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 action plan is preferred if sql server is not responding?

1107

How do I get to sql server configuration manager?

1014

What is the cpu pressure?

1049

What is the difference between indexing and hashing?

1175

Determine when to use stored procedure to complete sql server tasks?

1059

How is a full-text index updated?

959

How do we know if any query is retrieving a large amount of data or very little data?

979

Explain error and transaction handling in sql server?

1018

What is logon trigger?

1105

What is the Control Flow in SSIS

1098

What is Replication?

1054

List the different types of joins?

1014

What happens if the update subquery returns multiple rows in ms sql server?

1127

Which is better statement or preparedstatement?

935

Explain log shipping and mention its advantages.

1047