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
What is resultset concur_updatable?
How to use transact-sql statements to access the database engine?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Explain the dirty pages?
What are sub reports?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
How to retrieve error messages using mssql_get_last_message()?
What do you understand by a stored procedure?
What is change data capture (cdc) in sql server 2008?
Why use stored procedures in sql server?
Can a table be created inside a trigger?
Explain security with sql azure?
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What are the types of sql server?
What are the Advantages of using CTE in sql server?