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
- 16137 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
Answer Posted / rajkumar v
select Owner, COUNT(*) as Total from table_name group by
Owner having COUNT(*)>1
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to manipulate data from one table to another table ?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
How to receive returning result from a query?
What is constraints and its types?
What is change data capture (cdc) in sql server 2008?
Explain sql delete command?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
What is sql injection? How to protect against sql injection attack?
Explain foreign key in sql server?
Can I save my report as html, excel or word? : sql server management studio
Why is replication required on the sql server?
Define inner join in sql server joins?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Explain alternate key, candidate key and composite key in sql server?
What is a join in sql? What are the types of joins?
