I got a little problem.
I want to show distinct results based on only one field of the record, field1.
Here's an example. I want to show records from Table1 and the number in field1 must
not show more than once.
If my table is this:
Table1
field1 field2 field3 field4
5 Five Five One
4 Four Four Bla
5 Five Five Blah
3 Three Three Bluh
5 Five Five Bla bla
6 Six Six Bl.a
8 Eight Eight B.La
9 Nine Nine Lba
3 Three Three LAb
I want to output this:
Output
field1 field2 field3 field4
5 Five Five Bla bla
6 Six Six Bl.a
8 Eight Eight B.La
9 Nine Nine Lba
3 Three Three LAb
Is there a way to do that? without making another table everytime? I mean, by an sql
command?
Thanks in advance.
PhistucK