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
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
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
What is named calculation? : sql server analysis services, ssas
What is the federation in sql azure?
How to delete an existing database user?
How will you hide an attribute? : sql server analysis services, ssas
How to count duplicated values in a column in ms sql server?
What is sql server locking?
What is the difference between clustered and non-clustered indexes in ms sql server?
What is entity data services?
Explain what is dbcc?
How to convert numeric values to integers in ms sql server?
What is the difference between DataRow.Delete() and DataRow.Remove()?
can you implement data mining in SSRS?
How to rebuild the master database?
What is cursors? And what are the different types of cursor?