List:General Discussion« Previous MessageNext Message »
From:Mogens Melander Date:November 22 2012 12:53pm
Subject:Re: Getting distinct values in diff columns
View as plain text  
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.

Thread
Getting distinct values in diff columnssagar bs22 Nov
Re: Getting distinct values in diff columnsMogens Melander22 Nov