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 / valibasha
Select owner from table where bike in(‘pulsar’,’Honda’) group by owner having count(*)>=1
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
Is a primary key unique?
Explain in brief how sql server enhances scalability of the database system?
what types of replication are supported in sql server? : Sql server database administration
How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?
What is the exact numeric data type in sql?
How many categories of functions based their return modes?
Explain different types of lock modes in sql server 2000?
Why I can not enter 0.001 second in date and time literals in ms sql server?
Is INSTEAD OF trigger directly applicable to Table ?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
What are the differences between left join and inner join in sql server?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
what happens on checkpoint? : Sql server database administration
Explain about the command-line tool SQLCMD?
What is the difference between mysql and sql server?