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 are functions in the sql server?
what changed between the previous version of sql server and the current version? : Sql server database administration
Explain differences between web edition and business edition?
What’s the distinction between dropping a info and taking a info offline?
Can you import Microsoft Excel data to SSRS?
How to connect a database with sql express.?
How retrieve field names from the table in SQL through JAVA code?
What are sub reports?
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration
What is the command dbcc checkdb used for?
How many types of subqueries are there in sql server?
What is normalization 1nf 2nf 3nf?
What are the types of processing and explain each? : sql server analysis services, ssas
Explain the usage of floor function in sql server.
How to find Duplicate Records In table?