Search problem with Order BY

[pelillom]

I have a DB where object data like width, length and height are stored. I am able to search the data base for all object where width=X, but in cases where there are multiples, how can I also sort by the height?

Width Height
25.4 10

25.4 11.5
25.4 14
25.4 25.4
etc.

[wilku]

You can use

SELECT whatever WHERE Width = x ORDER BY Height, Length

[bradgrafelman]

In other words, you can specify multiple columns in an ORDER BY statement. If two rows have the identical value for the first column, the DB will then order those two rows according to the next column, etc. etc.