Skip to Content
0
Former Member
Jul 27, 2007 at 03:51 PM

about sql query(urgent)

14 Views

Hi experts,

i have one table with following entries.

Kunnr Material DateA DateB condition record

k1 M1 31.12.9999 03.12.2003 0000072152

k1 M1 31.12.9999 03.12.2004 0000072153

k1 M1 31.12.9999 03.2.2005 0000072154

k2 M2 31.12.9999 03.12.2003 0000072172

k2 M2 31.12.9999 03.12.2004 0000072172

From this table i need to get condition record on the base of material,customer

and dateb should be latest one.

How do i write query for this.

how to get get latest dateb .

O/p should be

k1 M1 31.12.9999 03.2.2005 0000072154

k2 M2 31.12.9999 03.12.2004 0000072172

thanks in advance.

thanks,

neo