OK, that worked. Thanks. Now lets try something a little different. Suppose I want to select the row where 'index' is max from among the rows where 'order_num' = something. For example, in my table I have 10 rows where 'order_num' is the same value, now I want to get the 1 row of those 10 where 'index' is max. I hope I explained that well enough.

And, no, my column name is not 'index', I just used that as an example. But I gather that using 'index' is bad practice?