select Owner, COUNT(*) as Total from table_name group by Owner having COU

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 / rajkumar v

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

Answer Posted / rajkumar v

select Owner, COUNT(*) as Total from table_name group by
Owner 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 are the restrictions while creating batches in sql server?

1118

Why use stored procedures in sql server?

1064

What is triggers and stored procedures?

991

How would you use user_constraints table in DB?

1061

What is the difference between for trigger and after trigger?

1163

What is the difference between join and inner join?

1074

How can we solve concurrency problems?

1098

What is transaction server distributed transaction?

1132

What you can do to delete a table without the delete trigger firing?

1013

explain databases and sql server databases architecture? : Sql server database administration

1015

How to create function without parameter in sql server?

1111

Do you know what are the steps to process a single select statement?

1020

Explain cdc and sql injection?

1045

Why use update_statistics command in sql server?

1113

Explain error handling in ssis?

1078