How to avoid redundant attributes in sql?

Asked Jan 14 '14 at 15:52

Active Jan 14 '14 at 15:52

Viewed 117 times

I currently have this table.

name               title
Robert Pattinson   Twilight
Daniel Radcliff    NULL
Leonardo Dicaprio  NULL
Charlie Chaplin    The kid
Charlie Chaplin    The Circus
Charlie Chaplin    Timelight
John Abraham       Dhoom
John Abraham       Race 2

Is there a way to avoid duplicate attributes like 'Charlie Chaplin' and get a result as follows?

name               title

Robert Pattinson   Twilight
Daniel Radcliff    NULL
Leonardo Dicaprio  NULL
Charlie Chaplin    The kid, The Circus,Timelight
John Abraham       Dhoom,Race 2

edited Jan 14 '14 at 15:52

Tim Schmelter

450,073
74
686
939

asked Jan 14 '14 at 15:52

user3194672

2

Which DBMS are you using? Oracle? Postgres? – Jan 14 '14 at 15:53
You may want to check following question http://stackoverflow.com/questions/102317/how-to-get-multiple-records-against-one-record-based-on-relation – Petr Chudanic Jan 14 '14 at 18:36
Thnx a lot. It worked. – user3194672 Jan 15 '14 at 03:43

How to avoid redundant attributes in sql?

0 Answers0