Hi,

Let's say I have a U-SQL rowset called @data with 2 columns: a and b

What I want is to get a new rowset @data2 with the same column a, but I want every entry in @data2's column b to be the maximum value @data's column b.

I tried to do this: @data2 = SELECT a, MAX(b) AS b FROM @data

But this gives me the error: "Every element in a select item must match an expression in GROUP BY exactly unless it is a constant or aggregate function."

How can I solve this? Thanks.