ORDER BY क्लॉज के साथ MySQL व्यू कैसे बनाएं?

हम MySQL ORDER BY क्लॉज का उपयोग अपने परिणाम सेट में रिकॉर्ड को क्रमबद्ध करने के लिए कर सकते हैं। GROUP BY क्लॉज को व्यू के साथ समझने के लिए हम 'Info' नामक एक व्यू बना रहे हैं जो आधार तालिका 'Student_info' का उपयोग करता है जिसमें निम्न डेटा है:

mysql> Select * from Student_info;
+------+---------+------------+------------+
| id   | Name    | Address    | Subject    |
+------+---------+------------+------------+
|  101 | YashPal | Amritsar   | History    |
|  105 | Gaurav  | Chandigarh | Literature |
|  125 | Raman   | Shimla     | Computers  |
|  130 | Ram     | Jhansi     | Computers  |
|  132 | Shyam   | Chandigarh | Economics  |
|  133 | Mohan   | Delhi      | Computers  |
+------+---------+------------+------------+
6 rows in set (0.00 sec)

वाक्यविन्यास

Create or Replace View view_name AS Select_statements FROM table ORDER BY expression [ASC|DESC]

उदाहरण

mysql> Create or Replace View Info AS select ID, Name, Address , Subject FROM Student_info ORDER BY Name ASC;
Query OK, 0 rows affected (0.11 sec)
mysql> Select * from info;
+------+---------+------------+------------+
| ID   | Name    | Address    | Subject    |
+------+---------+------------+------------+
|  105 | Gaurav  | Chandigarh | Literature |
|  133 | Mohan   | Delhi      | Computers  |
|  130 | Ram     | Jhansi     | Computers  |
|  125 | Raman   | Shimla     | Computers  |
|  132 | Shyam   | Chandigarh | Economics  |
|  101 | YashPal | Amritsar   | History    |
+------+---------+------------+------------+
6 rows in set (0.00 sec)
mysql> Create or Replace View Info AS select ID, Name, Address , Subject FROM Student_info ORDER BY Name DESC;
Query OK, 0 rows affected (0.10 sec)
mysql> Select * from info;
+------+---------+------------+------------+
| ID   | Name    | Address    | Subject    |
+------+---------+------------+------------+
|  101 | YashPal | Amritsar   | History    |
|  132 | Shyam   | Chandigarh | Economics  |
|  125 | Raman   | Shimla     | Computers  |
|  130 | Ram     | Jhansi     | Computers  |
|  133 | Mohan   | Delhi      | Computers  |
|  105 | Gaurav  | Chandigarh | Literature |
+------+---------+------------+------------+
6 rows in set (0.00 sec)