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
- 12631 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
Answer Posted / vidhya
select count(*) as no_of_vehical,owner_name from vehicles group by owner_name having count(*)>=1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the different types of sql server replication? : sql server replication
What is log ldf?
How can I add Reporting Services reports to my application?
Explain what you mean by 3 tier architecture.
Do you know what is sql injection?
Is it possible to update the views? If yes, how, if not, why?
Where actually sql azure database is hosted?
What does it mean to invest in the index?
What are filegroups in sql server?
What are some examples of schemas?
What command do we use to rename a db, a table and a column?
Do comments need to go in a special place in sql server 2005?
Explain what are the different index configurations a table can have?
How to change a login name in ms sql server?
When I delete any data from a table, does the sql server reduce the size of that table?
