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
- 16145 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
How to encrypt data between dialogs?
What is a raid and what are different types of raid configurations?
How can you check the version of sql server?
How to convert a numeric expression from one data type to another?
How do I find the sql server version?
Can two tables have the same primary key?
Explain table valued parameters in sql server? Why tvp used?
What is role playing dimension with two examples? : sql server analysis services, ssas
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Distinguish between commit and rollback?
What are the advantages of having an index on the sql server?
What is the function of inner join?
What is the difference between varchar and nvarchar?
What encryption security is available in sql azure?
Explain about builtinadministrator?
