Is there a way to get the values in all the columns of a row when I use the max() function on one of the columns? ie. if I have a column in my table called "index" & I do select max(index) from myTable it just returns the value in that column. I need all the values in the row where index is "max". What's the easiest way to do this? Thanks...