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 / vidhya
select count(*) as no_of_vehical,owner_name from vehicles group by owner_name having count(*)>=1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is molap and its advantage? : sql server analysis services, ssas
Write a query to find 5th highest amount paid from the customer table.
How to truncate the log in sql server 2012? : sql server database administration
What is normalization of database? What are its benefits?
Tell me what is de-normalization and what are some of the examples of it?
How to execute function in stored procedure sql server?
Define a cross join?
Can you explain powershell included in sql server 2008?
What is a Join and explain its types?
what is database replicaion? : Sql server database administration
What is role playing dimension with two examples? : sql server analysis services, ssas
What is implicit mode in sql server?
How many types of local tables are there in sql server?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
what are database files and filegroups? : Sql server database administration