+ 1

Is SQRT an aggregate function?

7th Oct 2016, 10:40 AM
Sattar Hashemi khosroshahi
Sattar Hashemi khosroshahi - avatar
2 Respostas
+ 3
No. It is a scalar function SQL aggregate functions return a single value, calculated from values in a column. for eg: avg,count,first,last,max,min,sum SQL scalar functions return a single value, based on the input value. for eg:ucase,lcase,mid,len,round,now,format,sqrt,rand
12th Oct 2016, 5:45 PM
Sumita Das
Sumita Das - avatar
- 1
yeah its an aggregate function
7th Oct 2016, 1:39 PM
Rohit Kumar