select last update

[ddtpmyra]

My query results has 3 rows but I only wanted to select the max date or the last update. How can i do this? I only wanted to pick the most current date which is the last record below:

Result:
1038651 2007-05-11 RMARTINEZ In-Service
1038651 2007-07-03 Equip Ret Pend Return Pending
1038651 2007-03-07 Import Returned

Query:

    SELECT ticket_number, MAX(ticket_status_history.addedDate) AS OrderDate, MAX(ticket_status_history.Tech_id) AS Tech_id,max(description)
        FROM ticket_status_history WITH (NOLOCK)
        INNER JOIN ticket_status ON ticket_status.id = ticket_status_history.current_status
        WHERE 
 ticket_number=1038651
        GROUP BY ticket_number, description, ticket_number

[prabirchoudhury]

try without GROUP BY and add ORDER BY 'ticket_status_history.addedDate` DESC LIMIT 1 that would take the last update from the top

SELECT ticket_number, MAX(ticket_status_history.addedDate) AS OrderDate, MAX(ticket_status_history.Tech_id) AS Tech_id,max(description) 
        FROM ticket_status_history WITH (NOLOCK) 
        INNER JOIN ticket_status ON ticket_status.id = ticket_status_history.current_status 
        WHERE  
 ticket_number=1038651 ORDER BY ticket_status_history.addedDate DESC LIMIT 1

[charles07]

i used this,worked for me

select max(timestamp),method,id from tables where 1 group by method,id order by timestamp desc