Latihan Oracle Part 1

Latihan Oracle Part 1

10:54 PM
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 (")

2 comments


EmoticonEmoticon

Subscribe to: Post Comments (Atom)