经典sql

            string CmdStr = @"select * from                                         (select (ROW_NUMBER() OVER (order by usecount)) as r1,a.id,a.tagstr,a.sortid,(select COUNT(*) from use_FileLib where use_FileLib.tag=a.id ) 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 order by b.sortid                                        ";