Why is it the query arrangement different for SQRT and AVG? Can they use the same query arrangement | Sololearn: Learn to code for FREE!
Neuer Kurs! Jeder Programmierer sollte generative KI lernen!
Kostenlose Lektion ausprobieren
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 Antwort
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