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
- 15765 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 are the exceptions handled in sql server programming?
How to create percentile function?
What is explicit mode in sql server?
Where can you add custom error messages to sql server?
Which are the two editions in which SQL Azure database available?
Does a sql server 2005 select statement require a from?
What is an indexing technique?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
How many types of dimensions are there and what are they? : sql server analysis services, ssas
How to create new tables with "create table" statements in ms sql server?
Explain the purpose of indexes?
Explain view in sql server?
How can I check that whether automatic statistic update is enabled or not?
Working with TLogs
How do we know if any query is retrieving a large amount of data or very little data?
