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 / anand
hey thanks a lot, it is working but with slight modification
Select Count(*) as No-Vehicles, owner from table where
group by owner having count(*)>=1
Regards,
Anand
Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What do you understand by replication in sql server? Mention the different types of replication in sql server.
What is the concept of optimization?
How you can minimize the deadlock situation?
What is role playing dimension with two examples? : sql server analysis services, ssas
How to list all tables in the database using odbc_tables()?
What is an execution plan? How would you view the execution plan?
What is the difference between functions and stored procedures?
What is the recommended total size of your memory optimized tables?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Explain about thread and memory management process of SQL?
What are the properties of the relational tables?
How to stop a loop early with break statements in ms sql server?
How to view existing indexes on an given table using sys.indexes?
What command do we use to rename a database?
Difference between drill down and drill through report.