应该是第一句的执行效率要高一些================================== 在SQL Server 高手的大海中小心的行走 ==================================
看查询计划就可以知道 select top 1 * from tablename order by ID是pk --> topselect * from tablename where ID=(select min(ID) from tablename) 是 pk --> top-->汇总--用pk内连接
在SQL Server 高手的大海中小心的行走
==================================
select top 1 * from tablename order by ID是pk --> topselect * from tablename where ID=(select min(ID) from tablename)
是
pk --> top-->汇总--用pk内连接