Oracle入门学习（4）

SELECT语句(2)

 

SELECT LAST_NAME, TITLE, SALARY*COMMISSION_PCT/100 COMM FROM S_EMP;

 

  

SELECT LAST_NAME, TITLE, SALARY*NVL(COMMISSION_PCT,0)/100 COMM

 FROM S_EMP;

 

 

 

SELECT FIRST_NAME || LAST_NAME "Employees" FROM E_EMP;

 

DISTINCT关键字去除重复值

SELECT DISTINCT NAME FROM S_DEPT;