Select Count(*) as Bike_Count, Owmer from <TN> where Bike in('

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 / priestly george varghese

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

Answer Posted / priestly george varghese

Select Count(*) as Bike_Count, Owmer from <TN> where Bike
in('pulsar','Honda')
group by Owmer having count(*)>1

Is This Answer Correct ?

8 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is port 1433 secure?

1038

Do you know what are acid properties?

1122

What is equi join with example?

1227

How do you handle datasets larger than 50 gb?

164

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

170

Explain transaction server consistency?

1018

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

938

Does windows server 2016 come with sql server?

986

What is subreport?

144

How to reaname table name without using sp_Rename in sql server..?

1039

What are statistics?

1050

Can group by be used without aggregate functions?

966

What is isnull() operator?

1090

What is tempdb in sql server?

1027

How do you troubleshoot errors in a SQL Server Agent Job?

1104