|Subject||Re: [ib-support] Name of Returned Field|
|Author||Robert F. Tulloch|
> It is meant to tell the engine that you want a result set consisting of each DISTINCT row containing > the named columns.And the result set consists of the single column in the expression
with the DISTINCT applied.
> Or maybe he meant it was stupid to return a result instead of raising an error...with which I agree.Why should it raise and error?
select distinct substr(zip,1,5), namelast from newslet
Works just fine.