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
- 15370 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
Answer Posted / priestly george varghese
Select Count(*) as Bike_Count, Owmer from <TN> where Bike
in('pulsar','Honda')
group by Owmer having count(*)>1
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
What is key attribute?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Explain primary key and foreign key constraints?
How to delete an existing row with delete statements in ms sql server?
what is the difference between delete table and truncate table commands? : Sql server database administration
Is sql different from sql server?
How to find index size for each index on table?
Explain Normalization and DE normalization
Can you tell me about the concept of ER diagrams?
Explain what is sql server english query?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
What is data set in report?
What happens if date-only values are provided as date and time literals?
Can you leave a union at any time?
What is the difference between having clause and where clause in sql server?
