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 do you mean by sql server agent?
what method you can use to reduce the overhead of Reporting Services data sources?
How to execute a sql statement using mssql_query()?
Define candidate key, alternate key, and composite key.
Explain Geography datatype in SQL Server
what is a schema in sql server 2005? : Sql server database administration
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60
What is dirty read?
Do you know hot add cpu in sql server 2008?
Does group by or order by come first?
Explain syntax for viewing trigger?
What are the advantages to use stored procedures?
List all the types of user-defined functions?
What is a subquery in a select query statement in ms sql server?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?