Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12 Answers
- 15758 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
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 is format parameter in ssrs?
How to create a trigger for insert only?
What do you know about system database? : SQL Server Architecture
Tell me about joins in database system and explain each in detail.
What are orphan records?
What is the guest user account in sql server? What login is it mapped to it? : sql server security
List out what other servers you can use with ssrs?
What is the difference between primary key and unique constraints?
When to use null data driven subscription?
What are the hotfixes and patches in sql server?
How to create a local temporary stored procedure?
What are data files?
What is normalization of database?
What do you mean by sql server agent?
what is a deadlock? : Sql server database administration
