SQL Query Question

[MHenscheid]

Let me start with a simplified example:

I have a database with fields "size", "color" and "sort_order_by_size"

short example of what the table might look like:

Size, Color, sort_order_by_size
S, Grey, 1
S, Blue, 2
S, Yellow, 3
M, Grey, 4
M, Yellow, 5

What I want to do is grab all "distinct" sizes and sort according to the sort_order_by_size field. I want my recordset to look like:

Size, sort_order_by_size
S, 1
M, 4

How do I write a query to get this result?
If I do: "Select distinct size from table", I do not get my sorting.
If I do: "Select distinct size, sort_order_by_size from table order by sort_order_by_size" the entire table is returned, since each value of sort_order_by_size is unique.

Any one have any suggestions?

[imported__sam_]

Hello,

You did not explain why you want

Size, sort_order_by_size
S, 1
M, 4

and not e.g.

Size, sort_order_by_size
S, 3
M, 5

Nevertheless, what could work is this:

SELECT size, min(sort_order_by_size) FROM table GROUP BY size ORDER BY min(sort_order_by_size)

best regards

Sam

[MHenscheid]

Thanks for the reply! I will check it out.