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