This topic has been archived. It cannot be replied.
-
工作学习 / 专业技术讨论 / In SQL Server, I know SELECT TOP stmt, but how to find last record ? and how to find a specified record in which row? Thanks.
-xxu999(杰姆);
2005-6-14
(#2344983@0)
-
第一个问题，select top n from table1 order by column desc. 就是降序排列然后取前几条了。第二个，加 where 字句喽。
-hard20(hard20);
2005-6-14
(#2345094@0)
-
1.I mean how to find the nth in the TOP n ?
2.I mean how to get the row number. Thanks hard20.
-xxu999(杰姆);
2005-6-16
(#2349042@0)
-
1. select top N... the last record is the nth one you're to find. 2. row numder? there's no absolute row number, it will change by "where" and "order" clause, or you mean PK?
-mixer(Beginner);
2005-6-16
(#2349075@0)