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
- 12 Answers
- 13336 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
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 lookup override?
Explain the working of sql privileges?
Mention what are the core components of ssrs?
Name few endpoints exposed by ssrs 2012?
What is the difference between online clustering and Offline clustering?
what stored procedure can you use to display the current processes? : Sql server administration
Explain primary key, foreign key and unique key?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
What are dml triggers and types of dml triggers?
How you can change the database name in SQL SERVER?
Differentiate between a local and a global temporary table?
Give me a SQL Query to find out the second largest company?
What is difference between count (*) and count 1?
Tell me about normalization in DBMS.
Can you explain what are commit and rollback in sql?
