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
- 12551 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
Answer Posted / gaurav.verma4210
select count(*) as no_of_vehical,owner from MulBike group by owner having count(*)>=1
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to create an index on a view?
What is the purpose of object explorer and its features? : sql server management studio
Explain primary key in sql server?
What is user defined stored procedures?
What is outer join in sql server joins?
Define primary key?
what is the different types of backups available in sql server? : Sql server database administration
What is clustered vs nonclustered index?
What are a database and a data warehouse?
Name three of the features managed by the surface area configuration tool? : sql server security
What are the types of resultset?
What different steps will a sql server developer take to secure sql server?
Explain the first normal form(1nf)?
What is the difference between clustered and a non-clustered index?
What is tcl in sql server?
