3,491
社区成员
发帖
与我相关
我的任务
分享
select id from table1 where age > 21
-- 给你写了个例子,你参考一下。
SQL>
SQL> create table test(id int, name varchar(10), xh int);
Table created
SQL> begin
2 for x in 1..30 loop
3 insert into test values(dbms_random.value() * 100, 'XXX', x);
4 end loop;
5 commit;
6 end;
7 /
PL/SQL procedure successfully completed
SQL> create index ix_test on test(id, xh);
Index created
SQL> col id format a8;
SQL> col xh format a8;
SQL> select id, xh from test where id > 21;
ID XH
-------- --------
26 6
28 5
38 8
48 18
49 9
49 24
49 26
58 12
65 25
68 15
72 20
78 19
81 1
87 10
87 28
89 21
92 2
92 29
95 30
97 16
ID XH
-------- --------
97 17
100 4
22 rows selected
SQL> select id, xh, name from test;
ID XH NAME
-------- -------- ----------
81 1 XXX
92 2 XXX
14 3 XXX
100 4 XXX
28 5 XXX
26 6 XXX
3 7 XXX
38 8 XXX
49 9 XXX
87 10 XXX
3 11 XXX
58 12 XXX
3 13 XXX
3 14 XXX
68 15 XXX
97 16 XXX
97 17 XXX
48 18 XXX
78 19 XXX
72 20 XXX
ID XH NAME
-------- -------- ----------
89 21 XXX
13 22 XXX
15 23 XXX
49 24 XXX
65 25 XXX
49 26 XXX
3 27 XXX
87 28 XXX
92 29 XXX
95 30 XXX
30 rows selected
SQL> drop table test purge;
Table dropped
SQL>