OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » multiple rows

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

multiple rows [message #223732]

Sat, 10 March 2007 15:57

SUSAN1
Messages: 36
Registered: March 2007

Member

hi,
How can I remove multiple rows in a table?

Report message to a moderator

Re: multiple rows [message #223734 is a reply to message #223732]

Sat, 10 March 2007 16:24

Frank
Messages: 7901
Registered: March 2000

Senior Member

Do you mean how to remove duplicate rows?

Report message to a moderator

Re: multiple rows [message #223735 is a reply to message #223734]

Sat, 10 March 2007 16:25

SUSAN1
Messages: 36
Registered: March 2007

Member

yes

Report message to a moderator

Re: multiple rows [message #223736 is a reply to message #223734]

Sat, 10 March 2007 16:28

SUSAN1
Messages: 36
Registered: March 2007

Member

yes, but what problemet is that, I have 867 rows and dont know which column.title is like the other.

Report message to a moderator

Re: multiple rows [message #223737 is a reply to message #223736]

Sat, 10 March 2007 17:06

Frank
Messages: 7901
Registered: March 2000

Senior Member

huh?
Could you explain what you mean?

Report message to a moderator

Re: multiple rows [message #223738 is a reply to message #223737]

Sat, 10 March 2007 17:14

SUSAN1
Messages: 36
Registered: March 2007

Member

acctually, I have a table 'Movie'

and under this table has those columns:

ID, TITLE, TITLE_ORIGINAL, EDITION, YEAR, LENGTH, IMDB_ID, NO_OF_DISCS,REGION_ID,ASPECT_RATIO_ID, SCREEN_FORMAT_ID, MEDIA_TYPE_ID

and my question is:

How to find duplicate rows with SQL?

Report message to a moderator