Tuomas Ruohonen wrote:
Compare two rows in table, when result changes more than 2 query shows
only those rows. In this case query ignores 25,25,25,24,23 and shows
only 26,24 and 21. There should be always one number only if the number
is same, like 24 and 24, shows only one 24.
Is this even possible ? I hope you can understand what i mean in this
case...
I believe this should be be more appropriate in the postgresql user list.
Btw, the answer to your question is quite easy. Look at the 'DISTINCT'
keyword for SELECT queries :
http://www.postgresql.org/docs/8.4/interactive/sql-select.html
--
Maxime
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
