主题：向大家请教一条SQL语句。

 --不知道是不是这个意思,创建一个包含整数列的表,把数据放进去
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

 SELECT ROUND(Val,0) FROM TEST ORDER BY ROUND(Val,0)