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 / 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
What do you understand by replication in sql server? Mention the different types of replication in sql server.
How to create a view using data from another view?
What is difference between index seek vs. Index scan?
What is the maximum size of a dimension? : sql server analysis services, ssas
Does server sql treat char as a variable-length or fixed-length column?
Can another user execute your local temporary stored procedures?
Explain what are the restrictions that views have to follow? : SQL Server Architecture
What are group functions in query statements in ms sql server?
What is isolation levels?
Relational calculus is what type of language?
How to connect a database with sql express.?
Tell me about normalization in DBMS.
What information is maintained within the msdb database?
How do I create a stored procedure in dbml?
Find first and last day of current month in sql server