比如下行语句使用select检索数据,只想检索第一行满足条件的数据.谢谢
select cola,colb from t where year=2007
------解决方案--------------------------------------------------------
select top 1 cola,colb from t where year=2007
------解决方案--------------------------------------------------------
--用top 1
select top 1 cola,colb from t where year=2007
------解决方案--------------------------------------------------------
--如果是按百分比,可以用
select top 1 percent cola,colb from t where year=2007
------解决方案--------------------------------------------------------
set rowcount 1
select * from table
set rowcount 0