SQL查询的时候有多个满足的条件我只想返回第一个结果就行,该怎么改...答:用 top 1来返回一行,用 datediff(day,t1.FcheckDate, getdate())as 账龄 来进行日期相减 Select top 1 u2.fnumber as 仓库代码,u2.FName as 仓库名称,ti.fnumber as 物料代码 ,ti.FName as 物料名称 ,ti.FModel as 型号,u1.FBatchNo as 批号,tm.FName as 基本单位,cast(u1.FQty ...