Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 15797 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
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
How to defragment indexes with alter index ... Reorganize?
How is table type constraint applied to a table?
What are the differences between user defined functions and stored procedures?
Do you know data definition language, data control language and data manipulation language?
How ssrs maintain security?
Why variables called the most powerful component of ssis?
Explain the disadvantages/limitation of the cursor?
What are the different Topologies in which Replication can be configured?
What is measure group, measure? : sql server analysis services, ssas
Which language rdl files made of?
How to add code to the existing article (using improve article)?
How many types of the database links?
How to use group functions in the select clause in ms sql server?
What is sql server replication? : sql server replication
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
