How do I invert rows into columns?

I am trying to write a sql statement for a view that takes a table of class training in the structure:

student_num, training_date

and displays the student and last 4 times trained (there may be more or less than four times trained) it to the format:

student_num, training_date1, training_date2, training_date3, training_date4

I know how to get the number of times trained, and the first and the last times trained, with the count(*), min(*), and max(*) functions.

But how do I get the last four??? This is causing a brain meltdown!!

Any help from you SQL jockeys out there will be greatly appreciated.

Thanks.
Russell Foster. Received on Wed Mar 06 1996 - 00:00:00 CET