Teana轻灵的专栏

摘录学习笔记,铭记前进的每一步.hoho开始还是蛮简单的哦!Objectives @List the capabilities of sql select staements @Exectue a basic select statement @Differentiate between sql statements and Isql *plus comamndsBasic select stat

日常工作和学习多,为了方便查询,多半要用到这些函数 ,做个简单罗列 !用SQL进行函数查询ceil函数ceil(n),去大于等于数值n的最小整数    e:select mgr, mgr/100,ceil(mgr/100) from scott.emp;floor函数floor(n),取小于等于数值n的最大整数     e:select mgr, mgr/100,floor(mgr/100) fr

Objectives:After completing this lesson,you should be a able to do the following:Limit the rows retrieved by a querySort the rows retrieved by a queryLimiting the rows selected:     Restrict the rows