How to get the second last record in sql

;WITH QResult

AS (SELECT

ROW_NUMBER() OVER (

PARTITION BY ATN_Date, ATN_AstNo ORDER BY ATN_Date DESC

) AS Row

,ATN_No

,ATN_Number

,ATN_Date

,ATN_AstNo

FROM tblName)

SELECT

*

FROM QResult

WHERE row = 2

0

+1

select *  from emp where empid not in (     select top (         (select count(*) from emp) - 2     ) empid     from emp )

Refer to this example

+1

Hi Basit ,

depend upon ATN_Date and ATN_AstNo , what do you mean ?

If this code can solve your question?

+1