LIMIT

[MySQL  ] LIMIT start, count
[Postgres] LIMIT count  OFFSET start
[MySQL   ] SELECT * FROM table LIMIT 0,3;
[Postgres] SELECT * FROM table LIMIT 3 OFFSET 0;

GROUP BY

[MySQL   ] SELECT * FROM table GROUP BY code;   ←PostgresではNG
[Postgres] SELECT code FROM table GROUP BY code;

DISTINCT

[MySQL   ] SELECT DISTINCT code FROM table;
[Postgres] SELECT DISTINCT code FROM table;
[Postgres] SELECT DISTINCT ON(code) * FROM table;
Counter: 6464, today: 1, yesterday: 0

トップ   編集 凍結 差分 バックアップ 添付 複製 名前変更 リロード   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2013-09-24 (火) 14:56:23 (1518d)