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 / 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
What is blocking and how would you troubleshoot it? : sql server database administration
When we should use and scope of @@identity?
How can we remove orphan records from a table?
What are the events recorded in a transaction log?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
write an SQL query to list the employees who joined in the month of January?
What is the recursive stored procedure in sql server?
Give main differences between "Truncate" and "Delete".
Does a full backup include transaction log?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
How to list all columns in a table using odbc_columns()?
How to execute stored procedure and set temp table in sql server?
What are advantages of ssrs or why we should use ssrs?
What is subreport?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?