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
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
What are database states in ms sql server?
How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Define Joins?
Explain ranking functions?
When do you think a developer should use sql server-based cursors?
What is dbcc?
What do you know about normalization and de- normalization?
explain different types of cursors? : Sql server database administration
Why transaction is important?
Distinguish between commit and rollback?
What are the types of sql server?
What number aggregate functions are accessible there in sql?
Explain what are the events recorded in a transaction log?