DB2

DB2 教程

December 5, 2020
,
DB2

DB2 教程 排序 ORDER BY SELECT select_list FROM table_name ORDER BY expression1 [ASC | DESC], expression2 [ASC | DESC], ... 过滤 DISTINCT SELECT DISTINCT column_name1, column_name2, ... FROM table_name; IN WHERE publisher_id IN (100, 103, 105) LIMIT 行 LIMIT LIMIT 10 OFFSET 5; 也可以写成: LIMIT 5, 10 FETCH SELECT title, rating FROm books ORDER BY rating DESC FETCH FIRST 10 ROWS ONLY; 下一页: SELECT title, rating FROm books ORDER BY rating DESC OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY; DB2 类型 Integers 支持三种:SMALLINT (-32768 ~ 32767)、INT (31 bits)、BIGINT (63 bits)。示例: ...