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
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