边学边写,琐碎记载oracle
1、如何让列名中间含有空格
SELECT ENAME || ',' || ' ' || JOB "Employee and Title" FROM EMP;
2、按照多个关键字排列
SELECT ENAME, SAL, COMM FROM EMP ORDER BY SAL DESC,comm DESC;
SELECT ENAME || ',' || ' ' || JOB "Employee and Title" FROM EMP;
2、按照多个关键字排列
SELECT ENAME, SAL, COMM FROM EMP ORDER BY SAL DESC,comm DESC;