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

Explain the usage of floor function in sql server.

968

How to return the top 5 rows from a select query in ms sql server?

1146

Why and when do stored procedure recompile?

986

Can we use where and having clause together?

1050

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1215

What is repeatable read?

1025

How to connect to a sql server using odbc_connect()?

1160

How to make a column nullable?

1125

How to use user defined functions in expressions?

1094

What is Extended user-defined?

965

How do I create a stored procedure in dbml?

1015

Explain ms sql server reporting services vs crystal reports?

928

Write a query to include a constraint, to check whether the employee salary is greater than 5000?

1608

What are transactions in sql?

1069

How to disable stored procedure sql server?

1609