in reply to Choosing "best" - sorting hashes issue
create table measurements ( name varchar ,measurement int ,quality1 int ,quality2 int ,quality3 int );
Obviously, you'd substitute quality1/quality2/etc. with the names of the qualities.
Then, if you want the five measurements for Name1 ordered by size, you use the following SQL statement:
SELECT measurement, size FROM measurements WHERE name = 'Name1' ORDER BY size
Easy as pie.
Being right, does not endow the right to be rude; politeness costs nothing.
Being unknowing, is not the same as being stupid.
Expressing a contrary opinion, whether to the individual or the group, is more often a sign of deeper thought than of cantankerous belligerence.
Do not mistake your goals as the only goals; your opinion as the only opinion; your confidence as correctness. Saying you know better is not the same as explaining you know better.
|
|---|