ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] SQL where ¤£¦PÄæ¦ì§PÂ_°ÝÃD

[µo°Ý] SQL where ¤£¦PÄæ¦ì§PÂ_°ÝÃD

¦U¦ì¤j¤j¦n
·Q½Ð±Ð¤@¤U,¤U­±ªº°ÝÃD¸Ó¦p¦ó³B²z

select id from database1 where (¨ó°Ó¥æ´Á ¬O¤é´Á´N¥Î¥L¬°§PÂ_±ø¥ó¡A¨ó°Ó¥æ´ÁªÅ¥Õ«h¥H¥¿±`¥æ´Á¬°§PÂ_±ø¥ó¡A¥H«e­±ªº¥æ´ÁÄæ¦ìbetween between adate and bdate)
½Ð°Ý¦³³oºØWhere ¤£¤@©w¬O¬Y¤@­ÓÄæ¦ìªº®É­Ô¸Ó¦p¦ó¼¶¼gSQL»yªk?
PKKO

where IIf(·~°È­q³æ.¨ó°Ó¥æ´Á is null, ·~°È­q³æ.«È¤á¥æ´Á, ·~°È­q³æ.¨ó°Ó¥æ´Á) between adate and bate

¥H¤W¤w¸g§¹¦¨¥\¯à,¥´ÂZ¤F©êºp
PKKO

TOP

        ÀR«ä¦Û¦b : ¯à¥I¥X·R¤ß´N¬OºÖ¡A¯à®ø°£·Ð´o´N¬O¼z¡C
ªð¦^¦Cªí ¤W¤@¥DÃD