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
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 is function of CUBE ?
What are statistics?
What are the general features of sql server management studio? : sql server management studio
Explain identity in sql server?
Define cursor locking
What are triggers in ms sql server?
Can we do dml on views?
Explain about merge replications?
How to change parameter value inside the report?
when you create a database how is it stored? : Sql server database administration
Tell me what are cursors and when they are useful?
How to change the password of a login name in ms sql server?
Which joins are sql server default?
How to create view in stored procedure sql server?
What is a transact-sql statement?