Home Forums SQL Server 7,2000 T-SQL Find second highest RE: Find second highest
Melville
SSCommitted
Points: 1985
More actions
July 8, 2003 at 4:25 am
#464441
I don't think there are any problems with @@rowcount, but I would consider using min/max to get the row you want rather than top.