這跟

select min(begdate),max(enddate) from sometable;

有什麽分別？嘻嘻

所有跟帖： 

• 對應每個滿足條件的endate，找到對應的，最早的begindate -豬不才- ♀ (0 bytes) () 12/01/2009 postreply 10:35:44

• if looks like if... -HappyNow?!- ♂ (101 bytes) () 12/01/2009 postreply 10:36:42

• ：) -煙仔哥- ♂ (0 bytes) () 12/01/2009 postreply 11:35:08

• sorry, you are right. They are the same thing unless -豬不才- ♀ (22 bytes) () 12/01/2009 postreply 10:44:23

• Tel. # again? -- -:)))!!! -HappyNow?!- ♂ (0 bytes) () 12/01/2009 postreply 10:53:47

• 嗬嗬，那你承認了先？ -豬不才- ♀ (0 bytes) () 12/01/2009 postreply 10:58:45

• 那應該用sometable and someothertable,這就不會混肴了 -煙仔哥- ♂ (0 bytes) () 12/01/2009 postreply 11:34:35