MVSFORUMS.com

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

I have a table INASBU with definition as :

kolusu · Posted: Mon Nov 10, 2003 8:42 am Post subject:

Vani,

Try this

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

Did not work
Distinct can be used only once

Any other solution?

sri_naveen · Posted: Mon Nov 10, 2003 11:29 pm Post subject:

Hi vani...try this..

SELECT MAX(GDAT) FROM <your table T1>, <same table T2>
WHERE T1.NLBKZ <> T2.NLBKZ
AND <same for other two>

this is a bit cumbursome...since its a full scan checking if its not equal..LI have no idea why multiple distinct dont work..which db are you using ?
_________________
Regards,
Naveen Srinivasan
Computer Sciences Corporation

--To err is human, to err again is more human--

vani · Beginner Joined: 28 May 2003 Posts: 51 Topics: 30

The below query worked. Thanks for all.

SELECT DISTINCT T.NLBID,T.NLBKZ,T.NLBBEZ,T.GDAT
FROM SAS1T01.INASBU T
WHERE T.GDAT = (SELECT MAX(GDAT)
FROM SAS1T01.INASBU
WHERE NLBID = T.NLBID);