I found the answer
From: Telus <sraisdana_at_l3technology.com>
Date: Thu, 15 Jan 2004 18:39:40 GMT
Message-ID: <M7BNb.17899$Eq.7584_at_clgrps12>
Date: Thu, 15 Jan 2004 18:39:40 GMT
Message-ID: <M7BNb.17899$Eq.7584_at_clgrps12>
Thanks Ana,
That table was just an example to show what I want,
I want one record whenever value of field 1 change
while I sorted records based on value of field 2,
I know it's not a regular SQL question, anyway I
could find a way with Select/Sub-Select and with
Lead and Over (they are analytical functions).
Thanks anyway - Sasan
Received on Thu Jan 15 2004 - 19:39:40 CET