首先要说你的表结构设计的不合理,为什么不加个登记时间字段呢,下面是我的处理方法:
DECLARE @A INT
SELECT @A=COUNT(*)-1 FROM table
EXEC('SELECT * FROM table WHERE name NOT IN(SELECT TOP '+@A+' name FROM table )')
DECLARE @A INT
SELECT @A=COUNT(*)-1 FROM table
EXEC('SELECT * FROM table WHERE name NOT IN(SELECT TOP '+@A+' name FROM table )')
DECLARE @A INT
SELECT @A=COUNT(*)-1 FROM table
EXEC('SELECT * FROM table WHERE name+sex+address NOT IN(SELECT TOP '+@A+' name+sex+address FROM table )')
from [table0]]
order by name desc