records in a table do not have instrinc order unless you order them by some columnssay,
select * from sometable order by somethingthen to achieve what you want, you can always do
select top 10 * from sometable order by something desc
select * from sometable order by somethingthen to achieve what you want, you can always do
select top 10 * from sometable order by something desc
所以必须转变你考虑问题的思路:
select top 10 * from youtable order by youfiledname desc
是一种方法。