| Subject | Re: What is difference between Distinct and Distinct(FieldName) | 
|---|---|
| Author | |
| Post date | 2015-03-17T21:46:11Z | 
Distinct is not a function, so the parentheses are useless noise.
it is the same difference as between
SELECT R.RDB$FIELD_ID, R.RDB$RELATION_NAME
FROM RDB$RELATIONS R
and
SELECT (R.RDB$FIELD_ID), R.RDB$RELATION_NAME
FROM RDB$RELATIONS R
            it is the same difference as between
SELECT R.RDB$FIELD_ID, R.RDB$RELATION_NAME
FROM RDB$RELATIONS R
and
SELECT (R.RDB$FIELD_ID), R.RDB$RELATION_NAME
FROM RDB$RELATIONS R