[ashok.c]

hi i m ashok
can anyone tell how to find the last two items in a field using sql server 2005

[lakshmi.n]

select top 2 column name from tablename order by columnname desc

or

select * from (select top 2 cname from tname
order by cname desc) a
order by cname


where cname=column name tname=tablename

i think its same query for sqlserver 2005 also

[ROBIN_signed]

select column_ name from table where table_id in(select max(table_id),max(table_id)-1, from table )

hope this helps also
alternative one for lakshmis query....