अवरोही क्रम के लिए ORDER BY DESC का उपयोग करें। मानों की गिनती के लिए COUNT() का उपयोग करें।
टेबल बनाएं
mysql> create table DemoTable (
-> EmployeeName varchar(100)
-> );
Query OK, 0 rows affected (0.85 sec)
रिकॉर्ड्स डालें
mysql> insert into DemoTable values('Sam');
Query OK, 1 row affected (0.17 sec)
mysql> insert into DemoTable values('David');
Query OK, 1 row affected (0.13 sec)
mysql> insert into DemoTable values('David');
Query OK, 1 row affected (0.31 sec)
mysql> insert into DemoTable values('Chris');
Query OK, 1 row affected (0.14 sec)
mysql> insert into DemoTable values('Robert');
Query OK, 1 row affected (0.11 sec)
mysql> insert into DemoTable values('Chris');
Query OK, 1 row affected (0.12 sec)
mysql> insert into DemoTable values('Sam');
Query OK, 1 row affected (0.13 sec)
mysql> insert into DemoTable values('Sam');
Query OK, 1 row affected (0.10 sec)
mysql> insert into DemoTable values('David');
Query OK, 1 row affected (0.11 sec)
mysql> insert into DemoTable values('Robert');
Query OK, 1 row affected (0.18 sec)
mysql> insert into DemoTable values('David');
Query OK, 1 row affected (0.16 sec)
mysql> insert into DemoTable values('Chris');
Query OK, 1 row affected (0.14 sec)
सभी रिकॉर्ड्स देखें
mysql> select * from DemoTable;
+--------------+ | EmployeeName | +--------------+ | Sam | | David | | David | | Chris | | Robert | | Chris | | Sam | | Sam | | David | | Robert | | David | | Chris | +--------------+ 12 rows in set (0.00 sec)
गिनती प्राप्त करके अवरोही क्रम में प्रदर्शित करने का क्वेरी
mysql> select EmployeeName, count(EmployeeName) as Total from DemoTable
-> group by EmployeeName
-> order by Total DESC;
आउटपुट:
+--------------+-------+ | EmployeeName | Total | +--------------+-------+ | David | 4 | | Chris | 3 | | Sam | 3 | | Robert | 2 | +--------------+-------+ 4 rows in set (0.00 sec)
मुख्य बिंदु:
GROUP BY EmployeeName- प्रत्येक नाम के लिए समूहCOUNT(EmployeeName)- प्रत्येक समूह में घटनाएं गिनेंAS Total- गिनती कॉलम का उपनामORDER BY Total DESC- गिनती के अनुसार अवरोही क्रम
