Subject | sql distinct syntax |
---|---|
Author | geo.mastique@laposte.net |
Post date | 2006-08-03T13:49:21Z |
hi,
i use the distinct sql intruction in a query so as to return only one
time a value :
select distinct myfield for mytable.
is it more quick to use a group by instruction ??? as :
select myfield for mytable
group by myfield
this question is maybe more sql topic than Firebird topic but maybe
firebird is better with the first or second instruction ???
tanks,
Julien
i use the distinct sql intruction in a query so as to return only one
time a value :
select distinct myfield for mytable.
is it more quick to use a group by instruction ??? as :
select myfield for mytable
group by myfield
this question is maybe more sql topic than Firebird topic but maybe
firebird is better with the first or second instruction ???
tanks,
Julien