group by to return 1 row.

[John Larsen]

Is it at all possible to group by and have it return all variables from 
a single row based on a max() criteria of a single variable?

For instance in SPSS I can sort by id number  descending then in an 
aggregate have it say that newvar2=first(newvar) or last(newvar).??

Just a thought?? any ideas?

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]