--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/981ff200-f0fa-da70-54da-2c84bc2fe95a%40tiscalinet.it.
Hello,
On 12.02.2021 at 12:40, Luigi Siciliano wrote:
No, distinct covers all selected fields. In the case you described
above, group by is a better solution:
select f1, f2, f3, min(f4), min(f5), min(f6)
from sometable
group by 1, 2, 3
Ok.
But honestly, I'd rethink this whole design. What good is this data if
you insert an arbitrary chosen record from among many with the same key
fields? The information value of the rest of the fields is dubious (you
could as well insert zeros or nulls for all non-key fields).
The query will be executed only once to populate the table whose data will then be examined by the user and possibly corrected. Subsequently the table will be updated, as needed, only with data selected by the user.
Thanks.
--Luigi Siciliano --------------------------
--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/dd605e22-d6b0-1d4c-baf5-0429517fb27d%40tiscalinet.it.