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
- 12696 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
Answer Posted / aditya
select name
from ( select name from bikehaving
where drive in ('pulsur',Homda')) xxx
group by name
having name > 1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the approximate numeric data types?
How do use Having,Group by,Group function in SQL?
What is a rownum?
Explain temporary table vs table variable by using cursor alternative?
what is denormalization? : Sql server database administration
What is correlated subquery in sql server?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
Do you think BCNF is better than 2NF & 3NF? Why?
what are the important architecture components of SSRS?
What is dynamic cursor in SQL SERVER?
What is the recommended total size of your memory optimized tables?
What is sql injection? How to protect against sql injection attack?
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
What are character string data types in ms sql server?
What happens if null values are involved in arithmetic operations?
