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
- 15354 Views
- Cognizant, TCS, I also Faced
- E-Mail Answers
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 to rename an existing column with the "sp_rename" stored procedure in ms sql server?
Is mysql the same as sql server?
How many levels of sp nesting is possible?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
How do I partition a table in sql server?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
How do I install sql server?
What is de-normalization and what are some of the examples of it?
how to do partition in sqlserver
What is postgresql server?
Who is the owner of a schema in ms sql server?
Difference between aggregate functions of sql?
How to locate and take substrings with charindex() and substring() functions?
Explain how to send email from sql database?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
