【SQL开源代码栏目提醒】:网学会员为需要SQL开源代码的朋友们搜集整理了397.sql相关资料,希望对各位网友有所帮助!
--创建数据表
CREATE TABLE tb_number20
(
num1 integer,
num2 integer
)
WITHOUT OIDS;
ALTER TABLE tb_number20 OWNER TO postgres;
--向表中插入数据
INSERT INTO tb_number20(
num1, num2)
VALUES (1, 1);
INSERT INTO tb_number20(
num1, num2)
VALUES (2, 2);
INSERT INTO tb_number20(
num1, num2)
VALUES (3, 3);
INSERT INTO tb_number20(
num1, num2)
VALUES (4, 4);
GO
CREATE INDEX "ind_N20"
ON tb_number20
USING btree
(num1, num2)
WHERE num2 > 2;