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 / valibasha
Select owner from table where bike in(‘pulsar’,’Honda’) group by owner having count(*)>=1
Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is difference between getdate and sysdatetime in sql server 2008?
How do you size a resultset?
How to drop an existing user defined function in ms sql server?
What is save transaction and save point?
What is 4nf in normalization form?
What is check constraint in sql server?
Is t sql the same as sql server?
What are basics of policy management?
What is an active database?
Do you know what are acid properties?
How can I track the changes or identify the latest insert-update-delete from a table?
Some queries related to SQL
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is the purpose of object explorer and its features? : sql server management studio
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?