°ÑÒ»¸öoracle²éѯÓï¾ä¸Ä³ÉSQLµÄ

select CanSell,Signed,Records,AveragePrice,housetype,addtime from AC_SellExhilarant where (floor(sysdate - addtime) =1 or floor(sysdate - addtime) = 0) and DISTRICT = :DISTRICT order by decode(Housetype,'סլÀà',0,'ÉÌÒµÀà',1,'°ì¹«Àà',2),AddTime DESC

ÇëÎʸ÷λ¸ßÊÖÕâ¸öÔõô¸Ä

---

SQL code:
select CanSell,Signed,Records,AveragePrice,housetype,addtime,
case when Housetype = 'סլÀà' then 0
when Housetype = 'ÉÌÒµÀà' then 1
when Housetype = '°ì¹«Àà' then 2
end rn
from AC_SellExhilarant
where (floor(sysdate - addtime) = 1 or floor(sysdate - addtime) = 0)
and DISTRICT = :DISTRICT
order by rn, AddTime DESC;


floorÏòÏÂÈ¡ÕûÕâ¸öº¯Êý±ê×¼sqlÖв»È·¶¨ÊÇ·ñÄÜÓûòÕßÓÐÏàËƵĺ¯Êý

---

²éÁËÏ£¬floorÊDZê×¼sqlÊýѧº¯Êý£¬¿ÉÒÔʹÓ㬵«ÊÇ»ñÈ¡µ±Ç°Ê±¼ä£¬sqlserver,mysql,oracle£¬db2,informix¶¼Óи÷×Ô²»Í¬µÄº¯Êý¡£
SQL code:
select CanSell,Signed,Records,AveragePrice,housetype,addtime,
from AC_SellExhilarant
where (floor(sysdate - addtime) = 1 or floor(sysdate - addtime) = 0)
and DISTRICT = :DISTRICT
order by case when Housetype = 'סլÀà' then 0
when Housetype = 'ÉÌÒµÀà' then 1
when Housetype = '°ì¹«Àà' then 2
end