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
- 13335 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 add a new dsn with the odbc driver for sql server?
What is function of master database?
What are the advantages of partitioning?
What are “lock” hints?
Explain indexing and what are the advantages of it?
What is set nocount on?
How to create a new login name in ms sql server?
What are binary string data types in ms sql server?
What are the types of resultset?
What is nolock?
Explain hostprotectionattribute in sql server 2005?
What happens when transaction log is full?
What is spatial and temporal data?
Beginning with sql server version 7 0, a new enhanced data type nchar was added what type of data is supported with this data type?
Explain syntax for dropping triggers?
