The correct Syntax is

CREATE PROCEDURE GET_CD_ARTISTS

AS

SELECT cd.CD_TITLE, a.ARTIST_NAME

FROM COMPACT_DISCS cd, ARTIST_CDS ac, ARTISTS a

WHERE cd.COMPACT_DISC_ID = ac.COMPACT_DISC_ID

AND ac.ARTIST_ID = a.ARTIST_ID;

Regards,

SAN -INDIA

Hi Anitha,

Please try below query

with m

as

(

select reqno, ROW_NUMBER() OVER(PARTITION BY reqno ORDER BY reqno) AS DuplicateCount

from mygroup

)

select * from m where DuplicateCount=2

Reagrds,

Sanjay K. Gope

Hi! Chris Morris

Thanx for reply

region IdParentIdText

a11wwer

b11yrt

c11ryrt

a11a1eryrty

b11b1nbnvnfth

c11c1vc

b111b11vbc

a111a11cb

c111c11bc

result should be

a11wwer

b11yrt

c11ryrt

then all rest values sort order by parent id

The major issues is this that the parent id is generated by...