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
- 12644 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
Why is the need for data conversion transformations?
How to use wildcard characters in like operations in ms sql server?
Why would you call update statistics?
what is datawarehouse?
Why functions are used in sql server?
how can you check the level of fragmentation on a table? : Sql server administration
What are the different types of locks in the database?
Can sql servers link to other servers?
What are the differences between char and nchar in ms sql server?
What is outer join in sql server joins?
What stored procedure would you use to view lock information?
How do we Backup SQL Azure Data?
What is RAID? What are the different types of RAID configurations?
what's the maximum size of a row? : Sql server database administration
What is Federation and Federation Member?
