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 / uttam sing rawat
select distinct Owner_Name from dbo.Tbl_Owner where bike
in(Select distinct bike from dbo.Tbl_Owner)
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Explain steps of normalization?
What is nolock hint in sql server 2008
How to delete duplicate rows in sql server?
What is the purpose of object explorer and its features? : sql server management studio
What is subquery explain with example?
What are the three different part of rdl file explain them?
What are various ways to enhance the ssrs report?
Tell me when is the update_statistics command used?
Define Wed Edition in SQL Azure?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
Define cursor locking
How to select all columns of all rows from a table with a select statement in ms sql server?
What are the types of joins in sql?
what are the critical issues you have resloved in your company
How can a database be repaired?