select iRecord,ord,count(DISTINCT iRecord) from(select top 1000 iRecord,0 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field7 like '%sales%') UNION select top 1000 iRecord,1 as ord from tblBoardRecord_1800000121_37 Where idCorp=1800000121 and iProject=37 and (field2 like '%sales%')) a where irecord<>52469 group by iRecord,ord order by ord asc,iRecord desc
中国投资指南网
Singapore sees retail sales down by 2.2 pct y-o-y in September
China's retail sales up 8.2 pct in Jan-Feb
Retail sales of consumer goods soaring in Tibet
U.S. retail sales see best growth in 6 years
China's retail sales up 8.1 pct in November