--不知道是不是这个意思,创建一个包含整数列的表,把数据放进去 CREATE TABLE TEST(Val REAL) INSERT INTO TEST (Val) VALUES (1) INSERT INTO TEST (Val) VALUES (1.01) INSERT INTO TEST (Val) VALUES (1.5) INSERT INTO TEST (Val) VALUES (2) INSERT INTO TEST (Val) VALUES (3) INSERT INTO TEST (Val) VALUES (3) INSERT INTO TEST (Val) VALUES (3.4) INSERT INTO TEST (Val) VALUES (3.45) INSERT INTO TEST (Val) VALUES (4)
CREATE TABLE TEST1(Val INT) INSERT TEST1(Val) (SELECT VAL FROM TEST)
SELECT * FROM TEST1
DROP TABLE TEST1 DROP TABLE TEST
|