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
- 12552 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
Explain the stored procedure?
What are the benefits of normalization?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
Mention the differences between having and where clause.
How do I start sql server 2017?
What is query and its types?
What are the different types of replication are there in sql server 2000?
What is sqlcmd?
How many types of local tables are there in sql server?
List out what other servers you can use with ssrs?
How do I install only the client tools of sql server 2000?
Differentiate between a local and a global temporary table?
List out the differences between the clustered index and non-clustered index in sql server?
What is the process of indexing?
What is the full form of ddl?
