1,beteween .. and ..=大于等于..小于等于..
SQL> select ku_id from wk_t_user
2 where ku_id between 2 and 15;
KU_ID
----------
2
11
12
13
2,in:用于离散取值中,或者关系;
SQL> select ku_id from wk_t_user
2 where ku_id in('2','11','15','20');
KU_ID
----------
2
11
3,like:模式匹配;
如:匹配以a开头的;
SQL> select ku_lid from wk_t_user
2 where ku_lid like 'a%';
KU_LID
--------------------
admin
audit
4,is null:查找为null的值;
SQL> select ku_id,ku_lid ,ku_name from wk_t_user
2 where ku_name is null;
KU_ID KU_LID KU_NAME
---------- -------------------- ----------------------------------------
1 guest
5,not:取反,即在关键字前加not
SQL> select ku_id ,ku_lid ,ku_name from wk_t_user
2 where ku_name is not null;
KU_ID KU_LID KU_NAME
---------- -------------------- ---------------------------
2 superman ?????????
11 admin ?????
12 info ????
6,排序:asc(缺省升序);desc降序;
SQL> select ku_id from wk_t_user
2 order by ku_id desc;
KU_ID
----------
13
12
11
2
7,可以以“别名”的方式进行排序;
8,order可跟多个字段进行排序;
注意:如order by ku_id,ku_lid desc中,desc只会作用紧挨着它的lu_lid,而ku_id会按照缺省的方式升序排序;
SQL> select ku_id ,ku_lid from wk_t_user
2 order by ku_id ,ku_lid desc
3 ;
KU_ID KU_LID
---------- --------------------
1 guest
2 superman
11 admin
12 info
13 audit