Hello, community!
I need a SQL query with the values of a table field of SQL Server 2012 shown as frequency distribution.
Let's say I have the field Sales (in R $), type float.
The lowest sale recorded was R $ 0.01 and the highest of R $ 1,000,345.23.
The detail is that I will never know which is the largest and the smallest selling.
There are hundreds of sales. I want to return the class frequencies. Each class will have a range of $ 100,000.00.
So my results would have to come in the form of a frequency distribution.
So,
The SQL Server 2012 table loads sales values:
Thequerybringsthevaluesdistributedinrange: