CREATE TABLE bikes (bikeID INT, CName VARCHAR(50), BNAME VARCHAR(50)) I

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

Question Posted / lakshmi narayanan r

12 Answers
15356 Views
Cognizant, TCS, I also Faced
E-Mail Answers

Answer Posted / lakshmi narayanan r

CREATE TABLE bikes (bikeID INT, CName VARCHAR(50), BNAME
VARCHAR(50))

INSERT INTO bikes(CName, BNAME) VALUES ('shanker', 'pulsar')
INSERT INTO bikes(CName, BNAME) VALUES ('shanker', 'Honda')
INSERT INTO bikes(CName, BNAME) VALUES ('shanker', 'car')
INSERT INTO bikes(CName, BNAME) VALUES ('Balu', 'pulsar')
INSERT INTO bikes(CName, BNAME) VALUES ('Balu', 'Honda')
INSERT INTO bikes(CName, BNAME) VALUES ('Balu', 'car')
INSERT INTO bikes(CName, BNAME) VALUES ('Shyam', 'pulsar')
INSERT INTO bikes(CName, BNAME) VALUES ('Jaya', 'Honda')
INSERT INTO bikes(CName, BNAME) VALUES ('Deepa', 'car')
INSERT INTO bikes(CName, BNAME) VALUES ('vasu', 'car')

;WITH tmp (RowId, CName) AS (SELECT ROW_NUMBER() OVER
(PARTITION BY CName ORDER BY BikeID ASC) AS RowId, CName
FROM Bikes)
SELECT DISTINCT CName FROM tmp WHERE RowId > 1

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain having clause and where clause?

989

How to insert a new row into a table with "insert into" statements in ms sql server?

913

What Is Rdbms?

1082

Is sql server a database?

924

What is history table in sql server?

895

What is a fan-out query in SQL Azure?

121

What are the benefits of filtered indexes?

977

What is sql stored procedure?

1017

What do you mean by sql server agent?

942

Can we linked SharePoint to a SQL database?

971

How does stuff differ from the replace function?

957

what purpose does the model database serve? : Sql server database administration

921

What is report server project?

134

what is a check constraint?

1038

What is cursor in ms sql server?

1090