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 / madhu sudhan g
Hii guys lets the table is Table_Bikes to get the answer the query is
with CTE(count,name)
AS
(
select count(1) as count,name from Table_Bikes Group By Name
)
select Name from CTE where count>1
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I view a trc file?
How do I edit a stored procedure in sql server?
Do you know nested transaction?
Difference between group by clause and having clause in SQL?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What is a rollup clause?
How do you improve the performance of a SQL Azure Database?
Define full outer join in sql server joins?
What is sql profiler. What are the default templates with it? : sql server database administration
What are the differences between web role and worker role?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
What is a print index?
What are rows and columns?
Difference between primary key and clustered index?
can an automatic recovery be initiated by a user? : Sql server administration