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
- 15369 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
How many joins in sql server?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
How to create database with physical files specified in ms sql server?
What are indexes in sql?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
How to divide query output into multiple groups with the group by clause in ms sql server?
What is an execution plan? How would you view the execution plan?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
What are the drawbacks of reporting in ssrs?
What is the architecture of ms sql reporting service?
What are the extra roles available in msdb? : sql server security
What is named calculation? : sql server analysis services, ssas
What is sql collation?
Explain how you can configure a running aggregate in SSRS?
Write down the syntax and an example for create, rename and delete index?
