[code=SQL] select top (5*1) Id from table where SourceId=22292 [/code] id 108 107 106 95 93 然后 [code=SQL] select min(tt.id) from (select top (5*1) Id from table &n ......
select b.AccountantID,dbo.hidtelpart(a.tel),midreceivedate, isnull(c.enddate,Dateadd(yy,1,midreceivedate)) as enddate, b.bankdate ,a.amount,DateDiff(mm,midreceivedate,enddate)as m from dbo.AccountantFinal as a join dbo.Accountant as b on a.SourceID=b.AccountantID --join CustomerEx ......
SQL code: select *,id=(select count(1)+1 from tb where user_id<a.user_id) from tb a 这条句子中的 where user_id<a.user_id是怎么比较的 user_id和a.user_id不是应该相同的吗？为什么带上这条where后id的之就是1，2，3，4，5，6，7..... ------------------------------------------- 自学很累，有时候很 ......
最新文章 : sql