Re: How to append information to simmilar data

From: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Fri, 08 Aug 2003 21:50:33 +0000
Message-ID: <3219487.1060379433@dbforums.com>

Try this:

select stu_fnm1||'.'||stu_surn||rk username, field2,field3 from ( select stu_fnm1, stu_surn, field2, field3 ect...

     , rank() over (partition by stu_fnm1, stu_surn
                        order by stu_fnm1, stu_surn) rk

from table1
where (stu_fnm1||'.'||stu_surn) in (select (stu_fnm1||'.'||stu_surn) from table1
GROUP BY stu_fnm1||'.'||stu_surn
HAVING Count(stu_fnm1||'.'||stu_surn)>1)) order by username

--
Posted via http://dbforums.com

Received on Fri Aug 08 2003 - 16:50:33 CDT