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
- 16172 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 the name of the Database which IBM mainframe uses?
How to loop through the result set with @@fetch_status?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What is a cursor, index in sql?
Why do we use functions?
What is trace flag in sql server?
What type of locking occurs during the snapshot generation? : sql server replication
Are connections to sql server encrypted?
What does select 1 mean?
What are the types of indexing?
What is de-normalization and what are some of the examples of it?
What are the different types of upgrades that can be performed in sql server?
How can I tell if sql server is 32 or 64 bit?
How to get a list all databases on the sql server?
Do you know what guidelines should be followed to help minimize deadlocks?
