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
- 12697 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
Answer Posted / priestly george varghese
Select Count(*) as Bike_Count, Owmer from <TN> where Bike
in('pulsar','Honda')
group by Owmer having count(*)>1
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What are three major types of constraints?
can we have a nested transaction? : Sql server database administration
How to list all triggers in the database with sys.triggers in ms sql server?
What is the purpose of indexing?
How to insert data with null values?
what's new in sql server 2016?
What is Replication?
Explain try...catch with sql server?
What are the types of database schema? : sql server analysis services, ssas
What is the maximum size of a dimension? : sql server analysis services, ssas
Explain the difference between primary keys and foreign keys?
How to create user defined functions with parameters?
what is spatial nonclustered index
Define tool Manage Statistics in SQL Server 2000 query ?
What do you understand by recursive stored procedure?
