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
- 13334 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
Is BCNF better than 2NF & 3NF? Why?
What is query cost in sql server?
Explain system rowset functions?
What are the encryption mechanisms in sql server?
What is the difference between functions and stored procedures?
What are the database objects? : SQL Server Architecture
What is sql stored procedure?
Explain the difference between clustered and non-clustered index?
What are the different types of columns types constraints in the sql server?
How to list all login names on the ms sql server?
What programming language would you use to create embedded functions in ssrs?
How to create an multi-statement table-valued function?
What is the difference between dbcc indexdefrag and dbcc reindex?
What is RAID? What are the different types of RAID configurations?
Explain indexing and what are the advantages of it?
