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:

Expand|Select|Wrap|Line Numbers

     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

Expand|Select|Wrap|Line Numbers

 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

select last update

re: select last update

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about