Home » SQL & PL/SQL » SQL & PL/SQL » How to remove the duplicate rows (Oracle 10g)
How to remove the duplicate rows [message #353867] Wed, 15 October 2008 06:51 Go to next message
yogeshyl
Messages: 50
Registered: October 2007
Location: Silvassa
Member
If suppose i have three columns namely A,B & C ina result of sql query.

A--------B------------C
11-------89006--------5
11-------89007--------6
20------ 890010-------15
20-------890012-------5

Note:- 11 = 5 +6 &
20 = 15+5

For 11 the transaction nos. are 89006 & 89007 having qty 5 & 6 respectively. Therefore i want the number 11 to get displayed for the 89006 transaction no. only.

For any product qty of A send to sub-contractor the material received is against transaction nos. in Column B and its individual qty.


Please refer the attachment of query and its result.


Re: How to remove the duplicate rows [message #353870 is a reply to message #353867] Wed, 15 October 2008 07:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From your previous topic:
Michel Cadot wrote on Thu, 24 July 2008 07:54
Don't attach it, some of us can't download it, post it inline but please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel



Re: How to remove the duplicate rows [message #353877 is a reply to message #353867] Wed, 15 October 2008 07:44 Go to previous message
joy_division
Messages: 4644
Registered: February 2005
Location: East Coast USA
Senior Member
How do you choose which record gets displayed? And please do no say "the first one." Please be specific and literal.
Previous Topic: Problem while emailing attachment attachment
Next Topic: Spool
Goto Forum:
  


Current Time: Fri Dec 09 17:11:16 CST 2016

Total time taken to generate the page: 0.23096 seconds