# UPDATE 不能加 ORDER BY and LIMIT /* MySQL */ UPDATE abc SET aaa=1 WHERE id<=100 ORDER BY status DESC LIMIT 10
/* PostgreSQL */ /* 若有需求要用子句解決 */ UPDATE abc main SET aaa=1 FROM ( SELECT id FROM page_builder WHERE id<=100 ORDER BY status DESC LIMIT 10 ) sub WHERE main.id = sub.id
SELECT …. FROM xxx WHERE xxx=’2008/1/15′ –>會找不到符合的記錄 SELECT …. FROM xxx WHERE xxx BETWEEN ‘2008/1/15’ AND ‘2008/1/16’ –>會連 2008/1/16 的記錄也被找到 SELECT …. FROM xxx WHERE xxx >= ‘2008/1/15’ AND xxx<= ‘2008/1/15 23:59:59’ –>若記錄值是2008/1/15 23:59:59.50 ,會找不到
因此,可以寫成
SELECT …. FROM xxx WHERE xxx >= ‘2008/1/15’ AND xxx < ‘2008/1/16’