分组统计文本信息

文本信息

[root@mysql24 user_3306]# mysql -uroot -p3306 -e 'select * from test.emp' > test.txt
Warning: Using a password on the command line interface can be insecure.
[root@mysql24 user_3306]# cat test.txt 
EMPNO	ENAME	JOB	MGR	HIREDATE	SAL	COMM	DEPTNO
7369	SMITH	CLERK	7902	1980-12-17	800	NULL	20
7499	ALLEN	SALESMAN	7698	1981-02-20	1600	300	30
7521	WARD	SALESMAN	7698	1981-02-22	1250	500	30
7566	JONES	MANAGER	7839	1981-04-02	2975	NULL	20
7654	MARTIN	SALESMAN	7698	1981-09-28	1250	1400	30
7698	BLAKE	MANAGER	7839	1981-05-01	2850	NULL	30
7782	CLARK	MANAGER	7839	1981-06-09	2450	NULL	10
7788	SCOTT	ANALYST	7566	1982-12-09	3000	NULL	20
7839	KING	PRESIDENT	NULL	1981-11-17	5000	NULL	10
7844	TURNER	SALESMAN	7698	1981-09-08	1500	0	30
7876	ADAMS	CLERK	7788	1983-01-12	1100	NULL	20
7900	JAMES	CLERK	7698	1981-12-03	950	NULL	30
7902	FORD	ANALYST	7566	1981-12-03	3000	NULL	20
7934	MILLER	CLERK	7782	1982-01-23	1300	NULL	10

提取deptno所在列

[root@mysql24 user_3306]# cat test.txt | awk '{print $8}'
DEPTNO
20
30
30
20
30
30
10
20
10
30
20
30
20
10

排序

[root@mysql24 user_3306]# cat test.txt | awk '{print $8}' | sort -rn
30
30
30
30
30
30
20
20
20
20
20
10
10
10
DEPTNO

统计

[root@mysql24 user_3306]# cat test.txt | awk '{print $8}' | sort -rn | uniq -c
      6 30
      5 20
      3 10
      1 DEPTNO