Home » SQL & PL/SQL » SQL & PL/SQL » sql distinct row query (oracle 10g)
sql distinct row query [message #582121] Sat, 13 April 2013 10:10 Go to next message
pankajdurve
Messages: 18
Registered: April 2013
Location: MUMBAI
Junior Member
how to delete similar rows from database
which query should i use?
Re: sql distinct row query [message #582122 is a reply to message #582121] Sat, 13 April 2013 10:13 Go to previous messageGo to next message
BlackSwan
Messages: 22911
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>how to delete similar rows from database

what defines "similar rows? post SQL & results that show "similar rows".

>which query should i use?
use DELETE statement


all of the above begs the question, if you do not want similar rows in some table,
why did you allow them to be inserted in the first place?

If you never allow similar rows to be inserted, then you don't have to be bothered with figuring out how to eliminate them later.

[Updated on: Sat, 13 April 2013 10:24]

Report message to a moderator

Re: sql distinct row query [message #582123 is a reply to message #582121] Sat, 13 April 2013 10:45 Go to previous messageGo to next message
Michel Cadot
Messages: 59427
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 02 April 2013 17:58
Michel Cadot wrote on Tue, 02 April 2013 11:52
Please do NOT post in UPPER case, read OraFAQ Forum Guide.
We don't do homework, tell us what you searched, did and where you are stuck and we will help you to further.

2 good books for you:
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals
...



And a third one: Database SQL Reference.
And you can read SQL FAQ.

Regards
Michel

Re: sql distinct row query [message #582150 is a reply to message #582123] Sun, 14 April 2013 06:50 Go to previous message
Amine
Messages: 265
Registered: March 2010
Senior Member

Here is a good example http://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:1224636375004
Previous Topic: Print an update confirmation
Next Topic: EXECUTE IMMEDIATE HELP
Goto Forum:
  


Current Time: Sat Oct 25 11:50:39 CDT 2014

Total time taken to generate the page: 0.10004 seconds