Getting distinct values in diff columns

[sagar bs]

Hi all,


I have the table with two columns(account_name and order_date). In the
account_name col, some account names are only once and few account names
are twice and few others are 3/4/5 times and in col2 there is order_date.
For same account name there may be 2/3/4/5 different order dates.

Now I need to get distinct account names, and last order date, second last
order date ans so on in different columns.

Please help me out to solve the issue in mysql