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
- 15351 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
How to use union to merge outputs from two queries together in ms sql server?
How to specify the collation for a character data type in ms sql server?
What is the fastest way to permanently delete a 1 million row table named customers?
Do you know what are acid properties?
What is the significance of null value and why should we avoid permitting null values?
What is an inner join?
List out the differences between the clustered index and non-clustered index in sql server?
What is cursors?
How to sort query output in descending order in ms sql server?
What is database isolation in sql server? : sql server database administration
What is a collation?
What is collation sensitivity?
How can you start sql server in different modes?
How to check if a table is being used in sql server?
What is difference between sql and sql server?
