1、where
字符串需要加引号,区分大小写 where ename='Ellen'
日期值格式:
缺省默认 DD-MON-RR
比较运算符
2、order by
desc 降序 asc 升序,默认升序
字符串需要加引号,区分大小写 where ename='Ellen'
日期值格式:
缺省默认 DD-MON-RR
![](http://img.blog.itpub.net/blog/attachment/201804/3/31476473_1522742431mG0m.png?x-oss-process=style/bb)
比较运算符
![](http://img.blog.itpub.net/blog/attachment/201804/3/31476473_1522742757WT34.png?x-oss-process=style/bb)
2、order by
desc 降序 asc 升序,默认升序
![](http://img.blog.itpub.net/blog/attachment/201804/3/31476473_1522742880OiWl.png?x-oss-process=style/bb)
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31476473/viewspace-2152556/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31476473/viewspace-2152556/