S02053

This error occurs when the select statement with the keyword distinct does not contain all columns in the order by clause. For example:

def createMyTable(n) {
    intv = take(1..10, n)
    symbol = take(`a`b`c, n)
    id = rand(100, n)
    strv = take("abs" + string(1..10), n)
    doublev = rand(10.0, n)
    return table(intv, strv, doublev, id, symbol)
}

n = 100
t = createMyTable(n)

select DISTINCT id from t order by intv => The select clause with DISTINCT keyword must contain all ORDER BY columns.

Add all columns from the order by clause to the select statement with the keyword distinct.

select DISTINCT intv, id from t order by intv