SQL Server SELECT @VARIABLE = TOP 1

Question

I'm trying to perform the following in a stored procedure

DECLARE @TICKET_AGE INT
SELECT @TICKET_AGE = TOP 1 (DATEDIFF(second, DATE_ENTERED, GETDATE())/60) AS TICKET_AGE
FROM TICKETS

But it's giving error saying INCORRECT SYNTAX NEAR 'TOP' What am i doing wrong?

So i've updated my code to look like below...but now am getting Incorrect syntax near the keyword 'AS'.

    -- DECLARE VARIABLE
    DECLARE @TICKET_AGE INT

    -- PULL THE DATA
    SELECT TOP 1 @TICKET_AGE = (DATEDIFF(second, DATE_ENTERED, GETDATE())/60) AS TICKET_AGE
    FROM TICKETS
    WHERE LOWER(STATUS_DESCRIPTION) LIKE '%new%'
    ORDER BY DATE_ENTERED ASC

Answer 1

The TOP 1 comes before the variable:

SELECT TOP 1 @TICKET_AGE = DATEDIFF(second, DATE_ENTERED, GETDATE()) / 60
FROM TICKETS