Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15763 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
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
What do you mean by the term 'normalization'?
Why I am getting this error when dropping a database in ms sql server?
What is a mutating table error and how can you get around it?
What is stored in the mssqlsystemresource database? : sql server database administration
What is difference between unique and primary key?
What is the use of set nocount on/off statement?
What is the maximum row of a size?
Where sql server usernames and passwords are stored in a sql server?
Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.
What encryption security is available in sql azure?
What is the usage of sign function?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
What are the different types of triggers in SQL SERVER?
What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration
What is the benefit of normalization?
