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
- 16154 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
What is log cache in sql server?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
What is use of except clause?
Explain syntax for disabling triggers?
What are types of scd? : sql server analysis services, ssas
How to create a store procedure with encryption?
How you can add messages to the nt event log from within a stored procedure?
What are sp_configure commands and set commands?
what is nonclustered index
What are the two authentication modes in sql server?
What is indexed view? How to create it?
Explain sql server service broker?
What is constraints and its types?
How do I completely remove sql server instance?
What are the difference between primary keys and foreign keys?
