Something like:
select aname,max(adate)
group by aname;
On Thu, November 22, 2012 11:06, sagar bs wrote:
> 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
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
>
--
Mogens Melander
+66 8701 33224
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
