Compute Frequency Of Each Element In Column using SQL 2008
In this article I am going to explain how to Find Frequency Of Each Element In Column.
Introduction
Frequency of each element in column means number of occurrence of particular element in a column.
Example
Suppose we have a table named "Employee" given in following image and we need to find out the frequency of each salary of employee.
Following SQL query will find out the frequency distribution of salary in Employee table.