ticket no date
output must be:
how to do it if we apply coun and distinct funjction the output must be same....
Try aggr(max(Date),[Ticket No])
Hope it helps
thanks bro but i want the same functionality at backend in script then how to do it?
LOAD TicketNo, date(max(date)) as date
GROUP BY TicketNo;
As Rob said. It will work. Find the following attachment
Retrieving data ...