Home » SQL & PL/SQL » SQL & PL/SQL » multiple rows
multiple rows [message #223732] Sat, 10 March 2007 15:57 Go to next message
SUSAN1
Messages: 36
Registered: March 2007
Member
hi,
How can I remove multiple rows in a table?
Re: multiple rows [message #223734 is a reply to message #223732] Sat, 10 March 2007 16:24 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Do you mean how to remove duplicate rows?
Re: multiple rows [message #223735 is a reply to message #223734] Sat, 10 March 2007 16:25 Go to previous messageGo to next message
SUSAN1
Messages: 36
Registered: March 2007
Member
yes
Re: multiple rows [message #223736 is a reply to message #223734] Sat, 10 March 2007 16:28 Go to previous messageGo to next message
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.
Re: multiple rows [message #223737 is a reply to message #223736] Sat, 10 March 2007 17:06 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
huh?
Could you explain what you mean?
Re: multiple rows [message #223738 is a reply to message #223737] Sat, 10 March 2007 17:14 Go to previous messageGo to next message
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?

Re: multiple rows [message #223756 is a reply to message #223738] Sun, 11 March 2007 01:54 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Did you read the link in my previous post?
What did you not understand?
Re: multiple rows [message #223761 is a reply to message #223732] Sun, 11 March 2007 03:20 Go to previous messageGo to next message
SUSAN1
Messages: 36
Registered: March 2007
Member
the problem that I had it wasnt between two tables, jus one, I find solution for it now.
thanks
Re: multiple rows [message #223762 is a reply to message #223761] Sun, 11 March 2007 03:32 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
The solutions given in the link are all about a single table.
Previous Topic: Query Help!
Next Topic: matrialized
Goto Forum:
  


Current Time: Fri Dec 09 06:00:34 CST 2016

Total time taken to generate the page: 0.11145 seconds