Identificando registros unicos y diferrentes en consulta (DISTINCT)
Publicado por Juan MAnuel Gzz (2 intervenciones) el 11/09/2014 18:35:45
Cua´l es el equivalente en progress a hacer un SELECT DISTINCT en SQL?
Valora esta pregunta


0
FOR EACH SomeTable NO-LOCK WHERE SomeConditions BREAK BY SomeField:
IF FIRST-OF(SomeField) THEN
/* Do What You Want With The Record Here */
END.
FOR EACH SomeTable NO-LOCK WHERE SomeConditions BREAK BY SomeField1 BY SomeField2:
IF FIRST-OF(SomeField1) AND FIRST-OF(SomeField2) THEN
/* Do What You Want With The Record Here */
END.