Hi list,<br /><br />I was wondering if it was possible for a field in SQL query to return NULL if latter value is
exactlythe same ? - for given ORDER BY clause, I guess.<br />For example, query returns:<br /><br />xxyy 1 4 true<br
/>xxyy 5 7 true<br />xxyy 21 8 true<br />yyzz 5 1 false<br />yyzz 7 7 false<br />yyzz 8 34 false<br /><br
/>I'dlike the output to be:<br /><br /> xxyy 1 4 true<br />NULL 5 7 NULL<br /> NULL 21 8 NULL<br /> yyzz 5 1
false<br/>NULL 7 7 NULL<br />NULL 8 34 NULL<br /><br />Is there any magical trick to achieve this ?<br /><br
clear="all"/>regards<br />mk<br />