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
How to compare the top two records using sql?
How many joins in sql server?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
What is partitioned view?
Explain comment on transactions?
how would you improve etl (extract, transform, load) throughput?
Can coalesce return null?
How to identify current user in ssrs report?
What are locks in sql?
What are the different types of upgrades that can be performed in sql server?
What are key, name and value columns of an attribute? : sql server analysis services, ssas
What are the extra roles available in msdb? : sql server security
How to rebuild master databse?
How to provide values to user defined function parameters?
How to receive output values from stored procedures?