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
- 16135 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 efficient you are in oracle and SQL server?
Does the order of columns in update statements matter?
List down some advantages of sql stored procedure?
How to convert numeric values to integers in ms sql server?
How do I find query history in sql server?
What is the main difference between ‘between’ and ‘in’ condition operators?
What are the advantages of mirroring?
What is a transact-sql statement?
can any body tell me how to know the password of current user in sql server
What is a view and what are its advantages?
What is the data type of time?
ow to bring suspect mode datbase online from scratch
What are the advantages of stored procedure in sql server?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
Explain aggregate functions?
