mssql ÅÅÐòÎÊÌ⣿ÇóÖú

select * from todaytask where datediff("n",taskonlinetime,getdate()) <15 order by rank asc,addtasktime desc

ÕâÀï²éѯ 15·ÖÖÓÔÚÏßµÄÈÎÎñ ͨ¹ýrankºÍaddtasktimeÅÅÐò

rankÊýֵΪ0»òÕß1

ÏÖÔÚÏë¸Ä±ä²éѯ·½Ê½

ÒªÇó£º

µ±rankµÈÓÚ0 ʱºò ÏÔʾ 15·ÖÖÓÔÚÏßµÄÈÎÎñ

µ±rankµÈÓÚ1 ʱºò ÏÔʾ È«²¿ÈÎÎñ

rank²ÅÓÃascÅÅÐò¡£

ÓÃÒ»Ìõ²éѯÓï¾ä½øÐвéѯ¡£²»ÖªµÀÎÒ˵µÄ´ó¼ÒÃ÷°×²»£¿ºÇºÇ¡£

ÇóÖú£¬Ð»Ð»¡£

---

SQL code:
select
case rank when 0 then (select * from todaytask where datediff("n",taskonlinetime,getdate()) <15 order by rank asc,addtasktime desc)
else (select * from todaytask order by rank asc,addtasktime desc)
from
todaytask

---

ÒýÓÃ

SQL codeselectcase rankwhen0then (select*from todaytaskwheredatediff("n",taskonlinetime,getdate()) <15orderby rankasc,addtasktimedesc)else (select*from todaytaskorderby rankasc,addtasktimedesc)from 
t¡­

¹þ¹þ À§ÁË ÂÒдµÄ Â¥Ö÷±ðЦ»°

---

mssqlÓïÑÔÒªÓÃÓÚaspÍøÕ¾ÀïÃæµÄ¡£Ï£Íû¿ÉÒÔ²»Òª·ÖÐС£

---

À§ÁË£¬ÐÝÏ¢ÁË

---

²»»á,°ï¶¥.

---

up