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
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
How to insert data with null values?
How to check parameter value in stored procedure sql server?
How can I change procedure name in sql server?
How to change the name of a database user?
what is the difference between a primary key and a unique key? : Sql server database administration
What is the use of builtinadministrators group in sql server? : sql server security
What are the recovery models for a database?
wat wil hapn if we give the both read and deny read permission to user?
What is co-related sub query?
What are the different types of upgrades that can be performed in sql server?
mention different types of relationships in the dbms?
What is the purpose of sql profiler in sql server? : sql server database administration
What is a mutating table error and how can you get around it?
List all types of constraints in sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure?