I have a file with 5 columns say
EMPID EMPNAME SALARY DESIGNATION DEPARTMENT
101 AAAAAAA 100000 ENGINEER IT
102 BBBBBBB 100000 ADMIN ADMIN
103 CCCCCC 100000 MANAGER IT
104 DDDDDD 100000 ADMIN ADMIN
105 EEEEEEEE 100000 TEAM LEAD IT
106 FFFFFFFFF 100000 ENGINEER IT
107 GGGGGG 100000 ENGINEER IT
108 HHHHHHH 100000 MANAGER IT
109 IIIIIIIIIII 100000 TEAM LEAD IT
110 KKKKKKK 100000 HR HR
Now I would like to know
1) Distinct values in DESIGNATION column
By SQL, I can achieve this using
SELECT DISTINCT DESIGNATION FROM EMPLOYEE.
2) Distinct values in DESIGNATION column and its count.
By SQL, I can achieve this using
SELECT DISTINCT DESIGNATION, count(*) FROM EMPLOYEE group by DESIGNATION.
I would like to achieve the same results using DFSORT for the above file.
Please suggest me an idea.