select a.sun_newssys0,a.sun_newssys4,a.sun_newssys6 from sun_newssys a where (select count(*) from sun_newssys where sun_newssys0<a.sun_newssys0 and sun_newssys4=a.sun_newssys4)<10 and sun_newssys1=38 and sun_newssys4 in(1027,1028,1029,1030,1031,1032,1033,1034,1035) order by sun_newssys0 DESC
SHOW CREATE TABLE XXX
贴结果
show index from sun_newssys ;