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 / gangadharrao
select Owner from dbo.[table] where Bike in (select bike
from dbo.[table]) group by owner having count(*) >1
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Which table keeps information about stored procedures?
What is dbcc command in sql server?
What are page splits?
Your table has a large character field there are queries that use this field in their search clause what should you do?
How you can change a cross join into an inner join?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
Explain about analysis services?
what are constraints? : Sql server database administration
What are pessimistic lock and optimistic lock?
Explain sql server service broker?
What is the difference between a clustered index and a non-clustered index?
How to disable a login name in ms sql server?
What is temporary stored procedure?
Why variables called the most powerful component of ssis?
What are the basic functions for master, msdb, model, tempdb and resource databases?