神句

来源:互联网 发布:闪电网络究竟是什么 编辑:程序博客网 时间:2024/04/28 00:31
select * from (select (ROW_NUMBER() OVER (order by usecount)) as r1,a.id,a.tagstr,(select COUNT(*) from use_FileLib where use_FileLib.tag=a.id and use_FileLib.ownerid='admin') as usecount from use_tag a ) b,(select (ROW_NUMBER() OVER (order by sortid)) as r2,color from use_color) c where b.r1=c.r2

0 0
原创粉丝点击