Latihan Oracle Part 1

skema yang digunakan adalah HR practice oracle Fundamental 1

Soal :

Find the highest, lowest, sum, and average salary of all employees. Label the columns Maximum, Minimum, Sum, and Average, respectively. Round your results to the nearest whole number.

jawab:

SELECT ROUND(MAX(SALARY),0) "Maximum",
ROUND(MIN(SALARY),0) "Minimum",
ROUND(SUM(SALARY),0) "Sum",
ROUND(AVG(SALARY),0) "Average"
FROM employees;

catatan : ingat ketika membuat concat harus kutip 2 (")

Share this

Share on FacebookPlus on Google+