浏览 1662 次
该帖已经被评为新手帖
|
|
---|---|
作者 | 正文 |
发表时间:2008-03-28
最后修改:2008-12-25
SQL> select distinct ename,sal from emp order by deptno; select distinct ename,sal from emp order by deptno * ERROR at line 1: ORA-01791: not a SELECTed expression SQL> select distinct ename,sal from emp order by sal; ENAME SAL ---------- ---------- SMITH 800 JAMES 950 --------------------------------------------- ------------------------------------- select distinct upper(tyt.line_id) from total_yield_table tyt where site_id='Beijing' and product_family='Chen' and group_level='DPY' -- and Line_id ='D17CHEN03' and time_from-15 / 48>trunc(sysdate-15 / 48) and time_from<=sysdate order by upper(line_id) 声明:ITeye文章版权属于作者,受法律保护。没有作者书面许可不得转载。
推荐链接
|
|
返回顶楼 | |