Select Distinct Cant Be Done!!!!!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have three column in a combo box
width is 2 cm ,0 cm ,0cm

the 0cm has other functions

Question: i want to show the value of the first column distinctively, I used
"select distinct" but i still can see a lot of repeating values. The reason
is there are different values in column 2 and column 3. So how to ignore the
column 2 and column 3 but i want them to exist as column 2 and 3?

In short, i want to see different values in column 1 but maintaining the
column 2 and 3

Thanks in advance

Kennykee
 
kennykee said:
I have three column in a combo box
width is 2 cm ,0 cm ,0cm

the 0cm has other functions

Question: i want to show the value of the first column distinctively,
I used "select distinct" but i still can see a lot of repeating
values. The reason is there are different values in column 2 and
column 3. So how to ignore the column 2 and column 3 but i want them
to exist as column 2 and 3?

In short, i want to see different values in column 1 but maintaining
the column 2 and 3

Thanks in advance

Kennykee
Click to expand...

Given sample data of...

1 1 1
1 1 2
1 2 1
1 2 2
2 1 1
2 1 2

...exactly what would you want for output? If you want distinct values on column
1 then you have to decide which rows for the various values of columns 2 and 3
you want to discard. For example...

SELECT Field1, Min(Field2), Min(Field3) GROUP BY Field1

....would produce...

1 1 1
2 1 1

You could substitute most any other aggregate function for Min() and they would
give you only one value for the Group By field.
 
Thanks Rick
You are right

Rick Brandt said:
Given sample data of...

1 1 1
1 1 2
1 2 1
1 2 2
2 1 1
2 1 2

...exactly what would you want for output? If you want distinct values on column
1 then you have to decide which rows for the various values of columns 2 and 3
you want to discard. For example...

SELECT Field1, Min(Field2), Min(Field3) GROUP BY Field1

....would produce...

1 1 1
2 1 1

You could substitute most any other aggregate function for Min() and they would
give you only one value for the Group By field.
Click to expand...
 
Back
Top