OraFAQ Forum: Reports & Discoverer » duplicate records in reports

Home » Developer & Programmer » Reports & Discoverer » duplicate records in reports

Thu, 30 June 2005 08:30

jasbir_singh
Messages: 1
Registered: June 2005
Location: mangalore

Junior Member

hi all,
I have to write all duplicate records in one line in oracle reports
how can i do this
for e.g

v1(vendor) p1(part) p2
v2 p1 p3

thanks
Jasbir

Mon, 04 July 2005 01:46

shrinaw
Messages: 2
Registered: June 2005

Junior Member

as per ur msg:
this could be helpful
SELECT JOB,COUNT(JOB) FROM EMP
GROUP BY JOB
HAVING COUNT(JOB)>1

Previous Topic:	Compute
Next Topic:	Changing System Parameters in Runtime

Goto Forum:

]

Current Time: Wed May 06 05:03:31 CDT 2026