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
- 15779 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
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Can two tables share the same primary key?
How can you control the amount of free space in your index pages?
What does it mean to be in union?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is sql stored procedure?
Explain about service Broker functions?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
What is raid and what are different types of raid levels?
What happens if the update subquery returns multiple rows in ms sql server?
What happens if time-only values are provided as date and time literals?
Please explain what is “asynchronous” communication in sql server service broker?
How do I know if localdb is running?
Detail about query optimizer?
What is a view and what are its advantages?
