取排序后的第一条数据

来源:互联网 发布:python print 编辑:程序博客网 时间:2024/05/01 05:57

set rowcount 1 SELECT * FROM dbo.Scheme_Period ORDER BY Start_Date

or

select top 1 * FROM dbo.Scheme_Period ORDER BY Start_Date DESC

原创粉丝点击