Why is it the query arrangement different for SQRT and AVG? Can they use the same query arrangement | Sololearn: Learn to code for FREE!
Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок
0

Why is it the query arrangement different for SQRT and AVG? Can they use the same query arrangement

SELECT Salary, SQRT(Salary) FROM employees; SELECT AVG(Salary) FROM employees:

18th Aug 2020, 5:20 PM
Bankole Omodasola
Bankole Omodasola - avatar
1 ответ
0
SQRT is used to calculate the square root of a number, while AVG is used for calculating average value from several values or in this case, column data. I didn't clearly understand what you mean by "Can they use the same query arrangement". Can you elaborate on that part?
18th Aug 2020, 7:39 PM
Ipang