ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

Wrkqry

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Wrkqry

    hi
    anybody knows how to select distinct records in wrkqry.also group by functions....

  • #2
    Re: Wrkqry

    Try doing a count on the fields you want distinct, and setting a break level and sort on those fields. THis is quite an ugly way to do it, SQL would be much better at it ...
    Greg Craill: "Life's hard - Get a helmet !!"

    Comment

    Working...
    X