MSSQL and Oracle don't want DISTINCT clauses over TEXT/BINARY fields. In this case, we simply delete it because SELECT g.* guarantees unique records to be retrieved by the first field.
MSSQL and Oracle don't want DISTINCT clauses over TEXT/BINARY fields.
In this case, we simply delete it because SELECT g.* guarantees unique
records to be retrieved by the first field.

dilawar/moodle