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. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
