ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 永远的11

永远的11

原创 Linux操作系统 作者:杨奇龙 时间:2010-07-19 23:04:51 0 删除 编辑

SQL> with a as
  2  (select rownum p from dual connect by level <=21)
  3  select
  4   7+ ceil (
  5    ( 7+ ceil (
  6    ( 7+ ceil(p/3))
  7    /3))
  8    /3)
  9  from a;

7+CEIL((7+CEIL((7+CEIL(P/3))/3))/3)                                            
-----------------------------------                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                             
                                11                                                                                                             
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            
                                 11                                            

已选择21行。

 

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/22664653/viewspace-668419/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 信息统计的问题
请登录后发表评论 登录
全部评论
MySQL DBA NoSQL DEVOPS

注册时间:2009-10-07

  • 博文量
    1026
  • 访问量
    8206440