Home » Developer & Programmer » Reports & Discoverer » duplicate records in reports
duplicate records in reports [message #126004] Thu, 30 June 2005 08:30 Go to next message
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

Report message to a moderator

Re: duplicate records in reports [message #126367 is a reply to message #126004] Mon, 04 July 2005 01:46 Go to previous message
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 04 20:05:35 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.