ÇóÒ»ÌõSQLÓï¾ä

select top 500 * from nts_InfoData where class_oneid=4 and class_twoid=1 and usual1='³öÊÛ' and (usual2 between 150 and 10000 or (usual2>0 and usual2<1.00)) order by id desc 


ÒòΪusual2×Ö¶ÎÊÇ×Ö·û´®ÀàÐÍ£¬²¢ÇÒÓеÄÊý¾ÝÊÇ4.7 »ò12.5Ö®ÀàµÄ£¬ÎÒÔÚת»»Ê±¾Í³ö´íÁË£¬ÇëÎÊÎÒÒªÔõô°ÑËüת»»³É·ûµãÀàÐÍÔٱȽÏ

---

SQL code:
select top 500 *
from nts_InfoData where class_oneid=4 and class_twoid=1 and usual1='³öÊÛ'
and (convert(dec(18,3),usual2 )
between 150 and 10000 or (convert(dec(18,3),usual2 )>0 and convert(dec(18,3),usual2 )<1.00)) order by id desc

---

SQL code:
cast(usual2 as dec(18,1))

---

²»¿¼ÂÇÐÔÄÜ

SQL code:
select top 500 * from nts_InfoData where class_oneid=4 and class_twoid=1 and usual1='³öÊÛ' and (cast(usual2 as numeric(38,8)) between 150 and 10000 or (cast(usual2 as numeric(38,8))>0 and cast(usual2 as numeric(38,8))<1.00)) order by id desc

---

SQL code:
select
top 500 *
from
nts_InfoData where class_oneid=4 and class_twoid=1 and usu