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
- 15367 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
Answer Posted / anil
select ownername,count(bike) noofbikes from abikes group by ownername having Count(bike)>1
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How can I create a new template for import ? : sql server management studio
How do you use a subquery to find records that exist in one table and do not exist in another?
How to write character string constants or literals in ms sql server?
what are constraints? Explain different types of constraints? : Sql server database administration
What is the cartesian product of the table?
What is save transaction and save point?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
How to drop an existing stored procedure in ms sql server?
What do you mean by an execution plan? Why is it used? How would you view it?
What is update locks?
How would you use user_constraints table in DB?
Scalability, Availability, Integration with internet, etc.)?
What do you mean by subquery?
What are transactions in sql?
what is dbcc? : Sql server database administration
