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
What is the syntax for encrypting a column in SQL Server?
What is meant by Active-Passive and Active-Active clustering setup?
How to get the definition of a stored procedure back?
How to move database physical files in ms sql server?
What are the benefits and tasks of object explorer? : sql server management studio
How to insert stored procedure result into temporary table?
Can group functions be used in the order by clause in ms sql server?
Which tcl commands are available on the sql server?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
Can we add a cpu to sql server?
What are cursors? Explain the different types of cursors Enlist a few disadvantages of cursors.
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is the default Port No on which SQL Server listens?
What are the types of dml?
What is database dimension? : sql server analysis services, ssas