{"id":1723,"date":"2021-12-30T19:38:37","date_gmt":"2021-12-30T16:38:37","guid":{"rendered":"https:\/\/pc71.ru\/bez-rubriki\/sql-order-by-clause-select-order-by-clause-transact-sql\/"},"modified":"2021-12-26T19:39:27","modified_gmt":"2021-12-26T16:39:27","slug":"sql-order-by-clause-select-order-by-clause-transact-sql","status":"publish","type":"post","link":"https:\/\/pc71.ru\/bazy-dannyh\/mysql\/sql-order-by-clause-select-order-by-clause-transact-sql\/","title":{"rendered":"SQL: ORDER BY Clause. SELECT — ORDER BY Clause (Transact-SQL)"},"content":{"rendered":"
\u0421\u043e\u0434\u0435\u0440\u0436\u0430\u043d\u0438\u0435<\/p>
\u0421\u043e\u0437\u0434\u0430\u0439\u0442\u0435 \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u0434\u043b\u044f \u0434\u0435\u043c\u043e\u043d\u0441\u0442\u0440\u0430\u0446\u0438\u0438 \u0440\u0430\u0431\u043e\u0442\u044b \u043a\u043e\u043c\u0430\u043d\u0434. \u0414\u043b\u044f \u0440\u0430\u0431\u043e\u0442\u044b \u0432\u0430\u043c \u043f\u043e\u043d\u0430\u0434\u043e\u0431\u0438\u0442\u0441\u044f \u0441\u043a\u0430\u0447\u0430\u0442\u044c \u0434\u0432\u0430 \u0444\u0430\u0439\u043b\u0430: DLL.sql \u0438 InsertStatements.sql. \u041f\u043e\u0441\u043b\u0435 \u044d\u0442\u043e\u0433\u043e \u043e\u0442\u043a\u0440\u043e\u0439\u0442\u0435 \u0442\u0435\u0440\u043c\u0438\u043d\u0430\u043b \u0438 \u0432\u043e\u0439\u0434\u0438\u0442\u0435 \u0432 \u043a\u043e\u043d\u0441\u043e\u043b\u044c MySQL \u0441 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0435\u0439 \u043a\u043e\u043c\u0430\u043d\u0434\u044b (\u0441\u0442\u0430\u0442\u044c\u044f \u043f\u0440\u0435\u0434\u043f\u043e\u043b\u0430\u0433\u0430\u0435\u0442, \u0447\u0442\u043e MySQL \u0443\u0436\u0435 \u0443\u0441\u0442\u0430\u043d\u043e\u0432\u043b\u0435\u043d \u0432 \u0441\u0438\u0441\u0442\u0435\u043c\u0435):<\/p>\n
mysql -u root -p<\/p>\n
\u0417\u0430\u0442\u0435\u043c \u0432\u0432\u0435\u0434\u0438\u0442\u0435 \u043f\u0430\u0440\u043e\u043b\u044c.<\/p>\n
\u0412\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u0435 \u0441\u043b\u0435\u0434\u0443\u044e\u0449\u0443\u044e \u043a\u043e\u043c\u0430\u043d\u0434\u0443. \u041d\u0430\u0437\u043e\u0432\u0451\u043c \u0431\u0430\u0437\u0443 \u0434\u0430\u043d\u043d\u044b\u0445 \u00abuniversity\u00bb:<\/p>\n
CREATE DATABASE university;
USE university;
SOURCE
\n
SHOW DATABASES;<\/p>\n
CREATE DATABASE;<\/p>\n
USE SOURCE
4. \u0418\u043c\u043f\u043e\u0440\u0442 SQL-\u043a\u043e\u043c\u0430\u043d\u0434 \u0438\u0437 \u0444\u0430\u0439\u043b\u0430 .sql<\/span><\/h3>\n