Answers for "write any two differences between single row functions and aggregate functions. name two functions from each category."

single row functions vs multiple row functions

• Single Row Functions:(Lower, Upper, Substr, Length)
function that will run for each row and 
return value for each row.

Multiple Row Functions (Group functions, Aggregate functions):
(Count, MIN , MAX, AVG, SUM)
will run for multiple rows and return a single value

Posted by: Guest on January-28-2021

Code answers related to "write any two differences between single row functions and aggregate functions. name two functions from each category."

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "write any two differences between single row functions and aggregate functions. name two functions from each category."

Code answers related to "write any two differences between single row functions and aggregate functions. name two functions from each category."

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "write any two differences between single row functions and aggregate functions. name two functions from each category."

Code answers related to "write any two differences between single row functions and aggregate functions. name two functions from each category."

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us