初学sql的问题

[dmhorse]

SQL> l
1 select job,decode(job,'PRESIDENT','A',
2 'MANAGER','B',
3 'ANALYST','C',
4 'SALESMAN','D',
5 'CLERK','E',
6 'O') "GRADE"
7* from emp
SQL> /

查找的结果中title GRADE 显示不全，只有'G'，请问怎才能显示整个单词

[chenchen2003]

对于第一个问题.可以这样解决.
先执行COLUMN GRADE FOR A7,然后再运行以上的SQL语句.问题应该就可以解决了.

• 打赏
• 举报

回复 赞

[lianhg]

1)
sql> columns GRADE format a50
SQL> select job,decode(job,'PRESIDENT','A','MANAGER','B','ANALYST','C','SALESMAN','D','CLERK','E','O') "GRADE"
from emp

2) select ename,hiredate,to_char(hiredate,'DAY')
from emp
order by to_char(hiredate,'D')

• 打赏
• 举报

回复 赞

[chenchen2003]

第一个问题可以这样解决.SQL语句为:
select ename,hiredate,to_char(hiredate,'DAY') WEEK from emp ORDER BY WEEK;
以上两个问题,如果有别的更好的解决方案.请指教.

• 打赏
• 举报

回复 赞

[dmhorse]

thx

order by to_char(hiredate,'D')
是正确的,order by day of the week.

• 打赏
• 举报

回复 赞

[dmhorse]

还有一个问题

已经知一个DATE开column,取月中的星期几，然后按星期几进行排序

select ename,hiredate,to_char(hiredate,'DAY') from emp;

这个order by 应怎写啊？　

ENAME HIREDATE DAY
---------- --------- ---------
KING 17-NOV-81 MONDAY
MILLER 23-JAN-82 FRIDAY
BLAKE 01-MAY-81 THURSDAY
CLARK 09-JUN-81 MONDAY
JONES 02-APR-81 WEDNESDAY
05TIN 28-SEP-81 SUNDAY
ALLEN 20-FEB-81 THURSDAY
TURNER 08-SEP-81 MONDAY
WARD 22-FEB-81 SATURDAY
FORD 03-DEC-81 WEDNESDAY
SMITH 17-DEC-80 TUESDAY

如何写才能让DAY column可以按星期几来排序

• 打赏
• 举报

回复 赞