{"id":603,"date":"2024-07-08T16:14:32","date_gmt":"2024-07-08T13:14:32","guid":{"rendered":"https:\/\/road-to-heaven.viro35.ru\/?page_id=603"},"modified":"2025-01-14T09:11:03","modified_gmt":"2025-01-14T06:11:03","slug":"%d1%84%d1%83%d0%bd%d0%ba%d1%86%d0%b8%d0%b8-%d0%b8-%d0%be%d0%bf%d0%b5%d1%80%d0%b0%d1%82%d0%be%d1%80%d1%8b-sql","status":"publish","type":"page","link":"https:\/\/road-to-heaven.viro35.ru\/?page_id=603","title":{"rendered":"\u0424\u0443\u043d\u043a\u0446\u0438\u0438 \u0438 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u044b"},"content":{"rendered":"\n

\u0410\u0440\u0438\u0444\u043c\u0435\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0435 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u044b<\/h2>\n\n\n\n
%, MOD<\/td>\u0414\u0435\u043b\u0435\u043d\u0438\u0435 \u043f\u043e \u043c\u043e\u0434\u0443\u043b\u044e<\/td>11 % 5 = 1<\/td><\/tr>
*<\/td>\u0423\u043c\u043d\u043e\u0436\u0435\u043d\u0438\u0435<\/td>10 * 16 = 160<\/td><\/tr>
+<\/td>\u0421\u043b\u043e\u0436\u0435\u043d\u0438\u0435<\/td>98 + 2 = 100<\/td><\/tr>
—<\/td>\u0412\u044b\u0447\u0438\u0442\u0430\u043d\u0438\u0435<\/td>50 — 51 = -1<\/td><\/tr>
\/<\/td>\u0414\u0435\u043b\u0435\u043d\u0438\u0435<\/td>1 \/ 2 = 0.5<\/td><\/tr>
DIV<\/td>\u0426\u0435\u043b\u043e\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u043e\u0435 \u0434\u0435\u043b\u0435\u043d\u0438\u0435<\/td>10 DIV 4 = 2<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u041b\u043e\u0433\u0438\u0447\u0435\u0441\u043a\u0438\u0435 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u044b<\/h2>\n\n\n\n
NOT<\/td>\u041c\u0435\u043d\u044f\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430 \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u044f \u043d\u0430 \u043f\u0440\u043e\u0442\u0438\u0432\u043e\u043f\u043e\u043b\u043e\u0436\u043d\u044b\u0439<\/td><\/tr>
OR<\/td>\u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043e\u0431\u0449\u0435\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f \u0438\u0441\u0442\u0438\u043d\u043d\u043e, \u0435\u0441\u043b\u0438 \u0445\u043e\u0442\u044f \u0431\u044b \u043e\u0434\u043d\u043e \u0438\u0437 \u043d\u0438\u0445 \u0438\u0441\u0442\u0438\u043d\u043d\u043e<\/td><\/tr>
AND<\/td>\u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043e\u0431\u0449\u0435\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f \u0438\u0441\u0442\u0438\u043d\u043d\u043e, \u0435\u0441\u043b\u0438 \u043e\u043d\u0438 \u043e\u0431\u0430 \u0438\u0441\u0442\u0438\u043d\u043d\u044b<\/td><\/tr>
XOR<\/td>\u0412\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043e\u0431\u0449\u0435\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f \u0438\u0441\u0442\u0438\u043d\u043d\u043e, \u0435\u0441\u043b\u0438 \u043e\u0434\u0438\u043d \u0438 \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u0438\u043d \u0430\u0440\u0433\u0443\u043c\u0435\u043d\u0442 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0441\u0442\u0438\u043d\u043d\u044b\u043c<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

SUM <\/strong>— \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u0432\u043e\u0437\u0432\u0440\u0430\u0442\u0430 \u0441\u0443\u043c\u043c\u044b \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f<\/p>\n\n\n\n

<\/path><\/path><\/svg><\/span>
SELECT<\/span> <\/span>SUM<\/span>(aggregate_expression) <\/span>FROM<\/span> tables [WHERE conditions];<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\u0412\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c SQL \u043f\u0440\u0435\u0434\u043b\u043e\u0436\u0435\u043d\u0438\u0435 DISTINCT \u0432 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 SUM. \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043f\u0440\u0438\u0432\u0435\u0434\u0435\u043d\u043d\u044b\u0439 \u043d\u0438\u0436\u0435 SQL \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 SELECT \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0441\u043e\u0432\u043e\u043a\u0443\u043f\u043d\u044b\u0439 \u043e\u0431\u0449\u0438\u0439 \u043e\u043a\u043b\u0430\u0434 \u0441 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u043c\u0438 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f\u043c\u0438 \u043e\u043a\u043b\u0430\u0434\u043e\u0432, \u0433\u0434\u0435 \u043e\u043a\u043b\u0430\u0434 \u043f\u0440\u0435\u0432\u044b\u0448\u0430\u0435\u0442 25000 $ \u0432 \u0433\u043e\u0434.<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
SELECT<\/span> <\/span>SUM<\/span>(<\/span>DISTINCT<\/span> salary) <\/span>AS<\/span> <\/span>"Total Salary"<\/span> <\/span>FROM<\/span> employees <\/span>WHERE<\/span> salary > <\/span>25000<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
\u041c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f \u0432\u043d\u0443\u0442\u0440\u0438<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
SELECT<\/span> <\/span>SUM<\/span>(income - expenses) <\/span>AS<\/span> <\/span>"Net Income"<\/span> <\/span>FROM<\/span> gl_transactions;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
AVG<\/strong> — \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u0432\u043e\u0437\u0432\u0440\u0430\u0442\u0430 \u0441\u0440\u0435\u0434\u043d\u0435\u0433\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
SELECT<\/span> <\/span>AVG<\/span>(aggregate_expression) <\/span>FROM<\/span> tables [WHERE conditions];<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
MIN <\/strong>— \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u0432\u043e\u0437\u0432\u0440\u0430\u0442\u0430 \u043c\u0438\u043d\u0438\u043c\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
SELECT<\/span> <\/span>MIN<\/span>(aggregate_expression) <\/span>FROM<\/span> tables [WHERE conditions];<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
MAX <\/strong>—  \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u0432\u043e\u0437\u0432\u0440\u0430\u0442\u0430 \u043c\u0430\u043a\u0441\u0438\u043c\u0430\u043b\u044c\u043d\u043e\u0433\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
SELECT<\/span> <\/span>MAX<\/span>(aggregate_expression) <\/span>FROM<\/span> tables [WHERE conditions];<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
UPPER <\/strong>— \u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u0443\u0435\u0442 \u0432\u0441\u0435 \u0431\u0443\u043a\u0432\u044b \u0443\u043a\u0430\u0437\u0430\u043d\u043d\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u0438 \u0432 \u0432\u0435\u0440\u0445\u043d\u0438\u0439 \u0440\u0435\u0433\u0438\u0441\u0442\u0440<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
SELECT<\/span> <\/span>UPPER<\/span>(<\/span>'ms sql server'<\/span>);<\/span><\/span>\n--\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442: 'MS SQL SERVER'<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
LOWER <\/strong>—  \u043f\u0440\u0435\u043e\u0431\u0440\u0430\u0437\u0443\u0435\u0442 \u0432\u0441\u0435 \u0431\u0443\u043a\u0432\u044b \u0432 \u0443\u043a\u0430\u0437\u0430\u043d\u043d\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u0435 \u0432 \u043d\u0438\u0436\u043d\u0438\u0439 \u0440\u0435\u0433\u0438\u0441\u0442\u0440<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
SELECT<\/span> <\/span>LOWER<\/span>(<\/span>'SQL Server'<\/span>); <\/span><\/span>\n--\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442: 'sql server'<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
DESCRIBE<\/strong><\/p>\n\n\n\n
\u0414\u043b\u044f \u0442\u043e\u0433\u043e, \u0447\u0442\u043e\u0431\u044b \u0443\u0437\u043d\u0430\u0442\u044c \u0442\u0438\u043f\u044b \u0434\u0430\u043d\u043d\u044b\u0445 \u0430\u0442\u0440\u0438\u0431\u0443\u0442\u043e\u0432 \u043c\u043e\u0436\u043d\u043e \u0432\u044b\u043f\u043e\u043b\u043d\u0438\u0442\u044c SQL \u043a\u043e\u043c\u0430\u043d\u0434\u0443 DESCRIBE \u0438 \u0443\u043a\u0430\u0437\u0430\u0442\u044c \u043d\u0430\u0437\u0432\u0430\u043d\u0438\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u0410\u0440\u0438\u0444\u043c\u0435\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0435 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u044b %, MOD \u0414\u0435\u043b\u0435\u043d\u0438\u0435 \u043f\u043e \u043c\u043e\u0434\u0443\u043b\u044e 11 % 5 = 1 * \u0423\u043c\u043d\u043e\u0436\u0435\u043d\u0438\u0435 10 * 16 = 160 + \u0421\u043b\u043e\u0436\u0435\u043d\u0438\u0435 98 + 2 = 100 — \u0412\u044b\u0447\u0438\u0442\u0430\u043d\u0438\u0435 50 — 51…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-603","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=\/wp\/v2\/pages\/603","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=603"}],"version-history":[{"count":28,"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=\/wp\/v2\/pages\/603\/revisions"}],"predecessor-version":[{"id":905,"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=\/wp\/v2\/pages\/603\/revisions\/905"}],"wp:attachment":[{"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=603"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}