{"id":576,"date":"2024-07-03T09:25:05","date_gmt":"2024-07-03T06:25:05","guid":{"rendered":"https:\/\/road-to-heaven.viro35.ru\/?page_id=576"},"modified":"2025-01-09T16:33:13","modified_gmt":"2025-01-09T13:33:13","slug":"%d0%bf%d1%80%d0%be%d0%b4%d0%b2%d0%b8%d0%bd%d1%83%d1%82%d0%be%d0%b5-%d0%b8%d1%81%d0%bf%d0%be%d0%bb%d1%8c%d0%b7%d0%be%d0%b2%d0%b0%d0%bd%d0%b8%d0%b5-select","status":"publish","type":"page","link":"https:\/\/road-to-heaven.viro35.ru\/?page_id=576","title":{"rendered":"\u0413\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0438 \u0438 \u0432\u044b\u0431\u043e\u0440\u043a\u0438"},"content":{"rendered":"\n

WHERE <\/strong>— \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 \u0434\u043b\u044f \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u0443\u0441\u043b\u043e\u0432\u0438\u0439 \u0432\u044b\u0431\u043e\u0440\u043a\u0438<\/p>\n\n\n\n

<\/path><\/path><\/svg><\/span>
SELECT<\/span> * <\/span>FROM<\/span> <\/span>table<\/span> <\/span>WHERE<\/span> condition<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
IN <\/strong>— \u041e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 IN \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u043e\u043a\u0440\u0430\u0449\u0435\u043d\u0438\u0435\u043c \u0434\u043b\u044f \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 OR \u0443\u0441\u043b\u043e\u0432\u0438\u0439.<\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
SELECT<\/span> * <\/span>FROM<\/span> CustomersWHERE Country <\/span>IN<\/span> (<\/span>'Germany'<\/span>, <\/span>'France'<\/span>, <\/span>'UK'<\/span>);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
BETWEEN <\/strong>— \u0432\u044b\u0431\u0438\u0440\u0430\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0432 \u0437\u0430\u0434\u0430\u043d\u043d\u043e\u043c \u0434\u0438\u0430\u043f\u0430\u0437\u043e\u043d\u0435. \u042f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u043d\u043a\u043b\u044e\u0437\u0438\u0432\u043d\u044b\u043c: \u043d\u0430\u0447\u0430\u043b\u044c\u043d\u043e\u0435 \u0438 \u043a\u043e\u043d\u0435\u0447\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0432\u043a\u043b\u044e\u0447\u0435\u043d\u044b. <\/p>\n\n\n\n
<\/path><\/path><\/svg><\/span>
SELECT<\/span> * <\/span>FROM<\/span> Products <\/span>WHERE<\/span> Price <\/span>BETWEEN<\/span> <\/span>10<\/span> <\/span>AND<\/span> <\/span>20<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
LIKE <\/strong>— \u043f\u043e\u0438\u0441\u043a \u0443\u043a\u0430\u0437\u0430\u043d\u043d\u043e\u0433\u043e \u0448\u0430\u0431\u043b\u043e\u043d\u0430 \u0432 \u0441\u0442\u043e\u043b\u0431\u0446\u0435<\/p>\n\n\n\n
    \n
  • \u0417\u043d\u0430\u043a \u043f\u0440\u043e\u0446\u0435\u043d\u0442\u0430 % \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u043d\u043e\u043b\u044c, \u043e\u0434\u0438\u043d \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0441\u0438\u043c\u0432\u043e\u043b\u043e\u0432.<\/li>\n\n\n\n
  • \u0417\u043d\u0430\u043a \u043f\u043e\u0434\u0447\u0435\u0440\u043a\u0438\u0432\u0430\u043d\u0438\u044f _ \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u044f\u0435\u0442 \u0441\u043e\u0431\u043e\u0439 \u043e\u0434\u0438\u043d, \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u044b\u0439 \u0441\u0438\u043c\u0432\u043e\u043b.<\/li>\n<\/ul>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> * <\/span>FROM<\/span> Customers <\/span>WHERE<\/span> CustomerName <\/span>LIKE<\/span> <\/span>'a%'<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    ESCAPE-\u0441\u0438\u043c\u0432\u043e\u043b<\/strong> — \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u044d\u043a\u0440\u0430\u043d\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f \u0441\u043f\u0435\u0446\u0438\u0430\u043b\u044c\u043d\u044b\u0445 \u0441\u0438\u043c\u0432\u043e\u043b\u043e\u0432 (% \u0438 \\). \u0412 \u0441\u043b\u0443\u0447\u0430\u0435 \u0435\u0441\u043b\u0438 \u0432\u0430\u043c \u043d\u0443\u0436\u043d\u043e \u043d\u0430\u0439\u0442\u0438 \u0441\u0442\u0440\u043e\u043a\u0438, \u0432\u044b \u043c\u043e\u0436\u0435\u0442\u0435 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c ESCAPE-\u0441\u0438\u043c\u0432\u043e\u043b.<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> job_id <\/span>FROM<\/span> Jobs <\/span>WHERE<\/span> progress <\/span>LIKE<\/span> <\/span>'3!%'<\/span> ESCAPE <\/span>'!'<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    CONCAT <\/strong>— \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u0435\u0442 \u0441\u043e\u0435\u0434\u0438\u043d\u044f\u0442\u044c \u0441\u0442\u0440\u043e\u043a\u0438.<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> <\/span>CONCAT<\/span>(<\/span>'SQL'<\/span>, <\/span>'Server'<\/span>);<\/span><\/span>\n--\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442: 'SQLServer'<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    SUBSTRING <\/strong>— \u043f\u043e\u0437\u0432\u043e\u043b\u044f\u044e\u0442 \u0438\u0437\u0432\u043b\u0435\u043a\u0430\u0442\u044c \u043f\u043e\u0434\u0441\u0442\u0440\u043e\u043a\u0443 \u0438\u0437 \u0441\u0442\u0440\u043e\u043a\u0438<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SUBSTRING<\/span>( string, start_position, <\/span>length<\/span> );<\/span><\/span>\nSELECT<\/span> <\/span>SUBSTRING<\/span>(<\/span>'MS SQL Server'<\/span>, <\/span>1<\/span>, <\/span>4<\/span>);<\/span><\/span>\n--\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442: 'MS S'<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    REPLACE <\/strong>— \u0437\u0430\u043c\u0435\u043d\u044f\u0435\u0442 \u043f\u043e\u0441\u043b\u0435\u0434\u043e\u0432\u0430\u0442\u0435\u043b\u044c\u043d\u043e\u0441\u0442\u044c \u0441\u0438\u043c\u0432\u043e\u043b\u043e\u0432 \u0432 \u0441\u0442\u0440\u043e\u043a\u0435 \u0434\u0440\u0443\u0433\u0438\u043c \u043d\u0430\u0431\u043e\u0440\u043e\u043c \u0441\u0438\u043c\u0432\u043e\u043b\u043e\u0432, \u0438 \u043d\u0435 \u0447\u0443\u0432\u0441\u0442\u0432\u0438\u0442\u0435\u043b\u044c\u043d\u0430 \u043a \u0440\u0435\u0433\u0438\u0441\u0442\u0440\u0443<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    REPLACE<\/span>( string1, string_to_replace, replacement_string )<\/span><\/span>\nSELECT<\/span> <\/span>REPLACE<\/span>(<\/span>'Ms SQL Server'<\/span>, <\/span>'S'<\/span>, <\/span>'z'<\/span>);<\/span><\/span>\n--\u0420\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442: 'Mz zQL zerver' (\u0418 \u0431\u043e\u043b\u044c\u0448\u0430\u044f S \u0438 \u043c\u0430\u043b\u044c\u043d\u044c\u043a\u0430\u044f s \u0431\u0443\u0434\u0443\u0442 \u0437\u0430\u043c\u0435\u043d\u0435\u043d\u044b \u043d\u0430 z)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    INSTR<\/strong> — \u041e\u0441\u0443\u0449\u0435\u0441\u0442\u0432\u043b\u044f\u0435\u0442 \u043f\u043e\u0438\u0441\u043a \u043f\u043e\u0434\u0441\u0442\u0440\u043e\u043a\u0438 \u0432 \u0441\u0442\u0440\u043e\u043a\u0435, \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u044f \u043f\u043e\u0437\u0438\u0446\u0438\u044e \u0435\u0451 \u043f\u0435\u0440\u0432\u043e\u0433\u043e \u0441\u0438\u043c\u0432\u043e\u043b\u0430. \u041f\u0440\u0438 \u044d\u0442\u043e\u043c \u043e\u0442\u0441\u0447\u0451\u0442 \u043d\u0430\u0447\u0438\u043d\u0430\u0435\u0442\u0441\u044f \u0441 \u0435\u0434\u0438\u043d\u0438\u0446\u044b, \u0430 \u043d\u0435 \u043d\u0443\u043b\u044f, \u043a\u0430\u043a \u0432 \u0431\u043e\u043b\u044c\u0448\u0438\u043d\u0441\u0442\u0432\u0435 \u044f\u0437\u044b\u043a\u043e\u0432 \u043f\u0440\u043e\u0433\u0440\u0430\u043c\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u0438\u044f.<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> INSTR(<\/span>'sql-academy'<\/span>, <\/span>'academy'<\/span>) <\/span>AS<\/span> idx;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    IF()<\/strong> —  \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435, \u0435\u0441\u043b\u0438 \u0443\u0441\u043b\u043e\u0432\u0438\u0435 \u0438\u043c\u0435\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0418\u0421\u0422\u0418\u041d\u0410, \u0438\u043b\u0438 \u0434\u0440\u0443\u0433\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435, \u0435\u0441\u043b\u0438 \u0443\u0441\u043b\u043e\u0432\u0438\u0435 \u0438\u043c\u0435\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u041b\u041e\u0416\u042c.<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> <\/span>IF<\/span>(<\/span>500<\/span><<\/span>1000<\/span>, <\/span>5<\/span>, <\/span>10<\/span>);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    CASE<\/strong> — \u043f\u0440\u043e\u0445\u043e\u0434\u0438\u0442 \u0447\u0435\u0440\u0435\u0437 \u0443\u0441\u043b\u043e\u0432\u0438\u044f \u0438 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435, \u043a\u043e\u0433\u0434\u0430 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u043f\u0435\u0440\u0432\u043e\u0435 \u0443\u0441\u043b\u043e\u0432\u0438\u0435<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> OrderID, Quantity,<\/span><\/span>\n  <\/span>CASE<\/span><\/span>\n    <\/span>WHEN<\/span> Quantity > <\/span>30<\/span> <\/span>THEN<\/span> <\/span>'The quantity is greater than 30'<\/span><\/span>\n    <\/span>WHEN<\/span> Quantity = <\/span>30<\/span> <\/span>THEN<\/span> <\/span>'The quantity is 30'<\/span><\/span>\n    <\/span>ELSE<\/span> <\/span>'The quantity is under 30'<\/span><\/span>\n  <\/span>END<\/span> <\/span><\/span>\n  <\/span>AS<\/span> QuantityText<\/span><\/span>\n  <\/span>FROM<\/span> OrderDetails;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    COUNT <\/strong>— \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0432\u043e\u0437\u0440\u0430\u0449\u0435\u043d\u043d\u044b\u0445 \u0437\u0430\u043f\u0440\u043e\u0441\u043e\u043c \u0441\u0442\u0440\u043e\u043a.<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> <\/span>COUNT<\/span>(\u0430\u0442\u0440\u0438\u0431\u0443\u0442 \u0438\u043b\u0438 *) <\/span>FROM<\/span> \u0442\u0430\u0431\u043b\u0438\u0446\u0430;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    NULL \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0432 \u044f\u0447\u0435\u0439\u043a\u0430\u0445 \u043d\u0435 \u0431\u0443\u0434\u0443\u0442 \u0443\u0447\u0442\u0435\u043d\u044b \u043f\u0440\u0438 \u043f\u043e\u0434\u0441\u0447\u0435\u0442\u0435.<\/p>\n\n\n\n
    \u041c\u043e\u0436\u043d\u043e \u0441\u0447\u0438\u0442\u0430\u0442\u044c \u0442\u043e\u043b\u044c\u043a\u043e \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> <\/span>COUNT<\/span>(<\/span>DISTINCT<\/span> department) <\/span>AS<\/span> <\/span>"Unique departments"<\/span> <\/span>FROM<\/span> employees <\/span>WHERE<\/span> salary > <\/span>48000<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    GROUP BY<\/strong> — \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0432 SELECT \u0434\u043b\u044f \u0441\u0431\u043e\u0440\u0430 \u0434\u0430\u043d\u043d\u044b\u0445 \u043f\u043e \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u043c \u0437\u0430\u043f\u0438\u0441\u044f\u043c \u0438 \u0433\u0440\u0443\u043f\u043f\u0438\u0440\u043e\u0432\u043a\u0438 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442\u043e\u0432 \u043e\u0434\u043d\u043e\u0433\u043e \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> expression1, expression2, ... expression_n,<\/span><\/span>\naggregate_function (aggregate_expression)<\/span><\/span>\nFROM<\/span> tables<\/span><\/span>\n[WHERE conditions]<\/span><\/span>\nGROUP BY<\/span> expression1, expression2, ... expression_n;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    \/* \u041f\u0440\u0438\u043c\u0435\u0440 \u2013 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u044f \u0444\u0443\u043d\u043a\u0446\u0438\u0438 SUM *\/<\/span><\/span>\nSELECT<\/span> department, <\/span>SUM<\/span>(sales) <\/span>AS<\/span> <\/span>"Total sales"<\/span><\/span>\nFROM<\/span> order_details<\/span><\/span>\nGROUP BY<\/span> department;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    \/* \u041f\u0440\u0438\u043c\u0435\u0440 \u2013 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 COUNT *\/<\/span><\/span>\nSELECT<\/span> department, <\/span>COUNT<\/span>(*) <\/span>AS<\/span> <\/span>"Number of employees"<\/span><\/span>\nFROM<\/span> employees<\/span><\/span>\nWHERE<\/span> salary > <\/span>25000<\/span><\/span>\nGROUP BY<\/span> department;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    \/* \u041f\u0440\u0438\u043c\u0435\u0440 \u2013 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 MIN *\/<\/span><\/span>\nSELECT<\/span> department, <\/span>MIN<\/span>(salary) <\/span>AS<\/span> <\/span>"Lowest salary"<\/span><\/span>\nFROM<\/span> employees<\/span><\/span>\nGROUP BY<\/span> department;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    HAVING <\/strong>— \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0432 \u0441\u043e\u0447\u0435\u0442\u0430\u043d\u0438\u0438 \u0441 GROUP BY, \u0447\u0442\u043e\u0431\u044b \u043e\u0433\u0440\u0430\u043d\u0438\u0447\u0438\u0442\u044c \u0433\u0440\u0443\u043f\u043f\u044b \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u043c\u044b\u0445 \u0441\u0442\u0440\u043e\u043a, \u0442\u043e\u043b\u044c\u043a\u043e \u0442\u0435\u0445, \u0447\u044c\u0438 \u0443\u0441\u043b\u043e\u0432\u0438\u044f \u0438\u0441\u0442\u0438\u043d\u043d\u044b<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> expression1, expression2, ... expression_n,<\/span><\/span>\naggregate_function (aggregate_expression)<\/span><\/span>\nFROM<\/span> tables<\/span><\/span>\n[WHERE conditions]<\/span><\/span>\nGROUP BY<\/span> expression1, expression2, ... expression_n<\/span><\/span>\nHAVING<\/span> condition;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    \u041f\u0440\u0438\u043c\u0435\u0440 — \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 SUM<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> department, <\/span>SUM<\/span>(sales) <\/span>AS<\/span> <\/span>"Total sales"<\/span><\/span>\nFROM<\/span> order_details<\/span><\/span>\nGROUP BY<\/span> department<\/span><\/span>\nHAVING<\/span> <\/span>SUM<\/span>(sales) > <\/span>1000<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    \u041f\u0440\u0438\u043c\u0435\u0440 — \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 COUNT<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> department, <\/span>COUNT<\/span>(*) <\/span>AS<\/span> <\/span>"Number of employees"<\/span><\/span>\nFROM<\/span> employees<\/span><\/span>\nWHERE<\/span> salary > <\/span>25000<\/span><\/span>\nGROUP BY<\/span> department<\/span><\/span>\nHAVING<\/span> <\/span>COUNT<\/span>(*) > <\/span>10<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    \u041f\u0440\u0438\u043c\u0435\u0440 — \u0418\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435 \u0444\u0443\u043d\u043a\u0446\u0438\u0438 MIN<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT<\/span> department, <\/span>MIN<\/span>(salary) <\/span>AS<\/span> <\/span>"Lowest salary"<\/span><\/span>\nFROM<\/span> employees<\/span><\/span>\nGROUP BY<\/span> department<\/span><\/span>\nHAVING<\/span> <\/span>MIN<\/span>(salary) > <\/span>35000<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    DISTINCT <\/strong>— \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0434\u043b\u044f \u0443\u0434\u0430\u043b\u0435\u043d\u0438\u044f \u0434\u0443\u0431\u043b\u0438\u043a\u0430\u0442\u043e\u0432 \u0438\u0437 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u0433\u043e \u043d\u0430\u0431\u043e\u0440\u0430<\/p>\n\n\n\n
    <\/path><\/path><\/svg><\/span>
    SELECT DISTINCT<\/span> expressions<\/span><\/span>\nFROM<\/span> tables<\/span><\/span>\n[WHERE conditions];<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
      \n
    • \u0415\u0441\u043b\u0438 \u0432 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0435 DISTINCT \u0443\u043a\u0430\u0437\u0430\u043d\u043e \u0442\u043e\u043b\u044c\u043a\u043e \u043e\u0434\u043d\u043e \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0435, \u0437\u0430\u043f\u0440\u043e\u0441 \u0432\u043e\u0437\u0432\u0440\u0430\u0442\u0438\u0442 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u044d\u0442\u043e\u0433\u043e \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u044f.<\/li>\n\n\n\n
    • \u0415\u0441\u043b\u0438 \u0432 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0435 DISTINCT \u0443\u043a\u0430\u0437\u0430\u043d\u043e \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0439, \u0437\u0430\u043f\u0440\u043e\u0441 \u0438\u0437\u0432\u043b\u0435\u043a\u0430\u0435\u0442 \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0435 \u043a\u043e\u043c\u0431\u0438\u043d\u0430\u0446\u0438\u0438 \u0434\u043b\u044f \u043f\u0435\u0440\u0435\u0447\u0438\u0441\u043b\u0435\u043d\u043d\u044b\u0445 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0439.<\/li>\n\n\n\n
    • \u0412 SQL \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 DISTINCT \u043d\u0435 \u0438\u0433\u043d\u043e\u0440\u0438\u0440\u0443\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f NULL. \u041f\u043e\u044d\u0442\u043e\u043c\u0443 \u043f\u0440\u0438 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0438 DISTINCT \u0432 \u0432\u0430\u0448\u0435\u043c \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0435 SQL \u0432\u0430\u0448 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0439 \u043d\u0430\u0431\u043e\u0440 \u0431\u0443\u0434\u0435\u0442 \u0441\u043e\u0434\u0435\u0440\u0436\u0430\u0442\u044c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 NULL \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0433\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f.<\/li>\n<\/ul>\n\n\n\n
      \u041f\u0440\u0438\u043c\u0435\u0440 — \u043f\u043e\u0438\u0441\u043a \u0443\u043d\u0438\u043a\u0430\u043b\u044c\u043d\u044b\u0445 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0439 \u0432 \u0441\u0442\u043e\u043b\u0431\u0446\u0435<\/p>\n\n\n\n
      <\/path><\/path><\/svg><\/span>
      SELECT DISTINCT<\/span> <\/span>state<\/span> <\/span>FROM<\/span> suppliers <\/span>ORDER BY<\/span> <\/span>state<\/span>;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
      ALIAS <\/strong>— \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u044b\u0435 \u0438\u043c\u0435\u043d\u0430 \u0434\u043b\u044f \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u0438\u043b\u0438 \u0442\u0430\u0431\u043b\u0438\u0446<\/p>\n\n\n\n
      <\/path><\/path><\/svg><\/span>
      SELECT<\/span> department, <\/span>MAX<\/span>(salary) <\/span>AS<\/span> highest<\/span><\/span>\nFROM<\/span> employees<\/span><\/span>\nGROUP BY<\/span> department;<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
        \n
      • MySQL ALIASES \u043c\u043e\u0436\u043d\u043e \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c \u0434\u043b\u044f \u0441\u043e\u0437\u0434\u0430\u043d\u0438\u044f \u0432\u0440\u0435\u043c\u0435\u043d\u043d\u043e\u0433\u043e \u0438\u043c\u0435\u043d\u0438 \u0434\u043b\u044f \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u0438\u043b\u0438 \u0442\u0430\u0431\u043b\u0438\u0446.<\/li>\n\n\n\n
      • COLUMN ALIASES \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442\u0441\u044f \u0434\u043b\u044f \u0443\u043f\u0440\u043e\u0449\u0435\u043d\u0438\u044f \u0447\u0442\u0435\u043d\u0438\u044f \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u0432 \u0432\u0430\u0448\u0435\u043c \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0438\u0440\u0443\u044e\u0449\u0435\u043c \u043d\u0430\u0431\u043e\u0440\u0435.<\/li>\n\n\n\n
      • TABLE ALIASES \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u0443\u044e\u0442\u0441\u044f \u0434\u043b\u044f \u0441\u043e\u043a\u0440\u0430\u0449\u0435\u043d\u0438\u044f \u0432\u0430\u0448\u0435\u0433\u043e SQL-\u043a\u043e\u0434\u0430, \u0447\u0442\u043e\u0431\u044b \u0443\u043f\u0440\u043e\u0441\u0442\u0438\u0442\u044c \u0435\u0433\u043e \u0447\u0442\u0435\u043d\u0438\u0435 \u0438\u043b\u0438 \u043a\u043e\u0433\u0434\u0430 \u0432\u044b \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0435 \u0441\u0430\u043c\u043e\u0441\u043e\u0435\u0434\u0438\u043d\u0435\u043d\u0438\u0435 (\u0442\u043e \u0435\u0441\u0442\u044c: \u043f\u0435\u0440\u0435\u0447\u0438\u0441\u043b\u0435\u043d\u0438\u0435 \u043e\u0434\u043d\u043e\u0439 \u0438 \u0442\u043e\u0439 \u0436\u0435 \u0442\u0430\u0431\u043b\u0438\u0446\u044b \u0431\u043e\u043b\u0435\u0435 \u043e\u0434\u043d\u043e\u0433\u043e \u0440\u0430\u0437\u0430 \u0432 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0435 FROM).<\/li>\n<\/ul>\n\n\n\n
        Subqueries (\u043f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441\u044b)<\/strong> — \u044d\u0442\u043e \u0437\u0430\u043f\u0440\u043e\u0441 \u0432 \u0437\u0430\u043f\u0440\u043e\u0441\u0435<\/p>\n\n\n\n
        <\/path><\/path><\/svg><\/span>
        SELECT<\/span> * <\/span><\/span>\nFROM<\/span> all_tables tabs<\/span><\/span>\nWHERE<\/span> tabs.table_name <\/span>IN<\/span> (<\/span>SELECT<\/span> cols.table_name<\/span><\/span>\n                          <\/span>FROM<\/span> all_tab_columns cols<\/span><\/span>\n                          <\/span>WHERE<\/span> cols.column_name = <\/span>'SUPPLIER_ID'<\/span>);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
        \u041f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441 \u0438 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 ALL<\/h2>\n\n\n\n
        \u0421 \u043f\u043e\u043c\u043e\u0449\u044c\u044e \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440\u0430 ALL \u043c\u044b \u043c\u043e\u0436\u0435\u043c \u0441\u0440\u0430\u0432\u043d\u0438\u0432\u0430\u0442\u044c \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435 \u0441 \u043a\u0430\u0436\u0434\u044b\u043c \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c \u0432 \u043d\u0430\u0431\u043e\u0440\u0435, \u043f\u043e\u043b\u0443\u0447\u0435\u043d\u043d\u044b\u043c \u043f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441\u043e\u043c. \u041f\u0440\u0438 \u044d\u0442\u043e\u043c \u0434\u0430\u043d\u043d\u043e\u0435 \u0443\u0441\u043b\u043e\u0432\u0438\u0435 \u0432\u0435\u0440\u043d\u0451\u0442 TRUE, \u0442\u043e\u043b\u044c\u043a\u043e \u0435\u0441\u043b\u0438 \u0432\u0441\u0435 \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u044f \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0433\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0441\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f\u043c\u0438 \u0432 \u043d\u0430\u0431\u043e\u0440\u0435 \u0432\u0435\u0440\u043d\u0443\u0442 TRUE.<\/p>\n\n\n\n
        \u041d\u0430\u043f\u0440\u0438\u043c\u0435\u0440, \u043d\u0438\u0436\u0435\u043f\u0440\u0438\u0432\u0435\u0434\u0451\u043d\u043d\u044b\u0439 \u0441\u0438\u043d\u0442\u0435\u0442\u0438\u0447\u0435\u0441\u043a\u0438\u0439 \u0437\u0430\u043f\u0440\u043e\u0441 \u043f\u0440\u043e\u0432\u0435\u0440\u044f\u0435\u0442 \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043b\u0438 \u0436\u0438\u043b\u044b\u0445 \u043f\u043e\u043c\u0435\u0449\u0435\u043d\u0438\u0439 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u0443\u0441\u043b\u043e\u0432\u0438\u0435, \u0447\u0442\u043e \u043e\u043d\u043e \u0434\u0435\u0448\u0435\u0432\u043b\u0435 \u0447\u0435\u043c 200.<\/p>\n\n\n\n
        <\/path><\/path><\/svg><\/span>
        SELECT<\/span> <\/span>200<\/span> > ALL(<\/span>SELECT<\/span> price <\/span>FROM<\/span> Rooms)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
        \u041f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441 \u0438 \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 ANY<\/h2>\n\n\n\n
        \u0423\u0441\u043b\u043e\u0432\u043d\u043e\u0435 \u0432\u044b\u0440\u0430\u0436\u0435\u043d\u0438\u0435 \u0441 ANY \u0438\u043c\u0435\u0435\u0442 \u0441\u0445\u043e\u0436\u0435\u0435 \u043f\u043e\u0432\u0435\u0434\u0435\u043d\u0438\u0435, \u043d\u043e \u043e\u043d\u043e \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u0435\u0442 TRUE, \u0435\u0441\u043b\u0438 \u0445\u043e\u0442\u044f \u0431\u044b \u043e\u0434\u043d\u043e \u0441\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u0435 \u043e\u0442\u0434\u0435\u043b\u044c\u043d\u043e\u0433\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0441\u043e \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u0435\u043c \u0432 \u043d\u0430\u0431\u043e\u0440\u0435 \u0432\u0435\u0440\u043d\u0451\u0442 TRUE.<\/p>\n\n\n\n
        <\/path><\/path><\/svg><\/span>
        SELECT<\/span> * <\/span>FROM<\/span> Users <\/span>WHERE<\/span> id = ANY (<\/span><\/span>\n    <\/span>SELECT DISTINCT<\/span> owner_id <\/span>FROM<\/span> Rooms <\/span>WHERE<\/span> price >= <\/span>150<\/span><\/span>\n)<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
        \u0421\u0440\u0430\u0432\u043d\u0435\u043d\u0438\u0435 \u043f\u043e \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u043c \u0441\u0442\u043e\u043b\u0431\u0446\u0430\u043c<\/h2>\n\n\n\n
        <\/path><\/path><\/svg><\/span>
        SELECT<\/span> * <\/span>FROM<\/span> Reservations   \/\/\u0441\u0440\u0430\u0432\u043d\u0438\u0432\u0430\u0435\u0442\u0441\u044f \u0446\u0435\u043b\u0438\u043a\u043e\u043c<\/span><\/span>\n    <\/span>WHERE<\/span> (room_id, price) <\/span>IN<\/span> (<\/span>SELECT<\/span> id, price <\/span>FROM<\/span> Rooms);<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
        \u041a\u043e\u0440\u0440\u0435\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0435 \u043f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441\u044b<\/h2>\n\n\n\n
        \u0412\u0441\u0435 \u043f\u0440\u0435\u0434\u044b\u0434\u0443\u0449\u0438\u0435 \u0440\u0430\u0441\u0441\u043c\u0430\u0442\u0440\u0438\u0432\u0430\u0435\u043c\u044b\u0435 \u043f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0431\u044b\u043b\u0438 \u043d\u0435\u043a\u043e\u0440\u0440\u0435\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0435 (\u043d\u0435\u0437\u0430\u0432\u0438\u0441\u0438\u043c\u044b\u0435). \u041e\u043d\u0438 \u043c\u043e\u0433\u043b\u0438 \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0442\u044c\u0441\u044f \u0430\u0432\u0442\u043e\u043d\u043e\u043c\u043d\u043e \u043e\u0442 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0433\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u0438 \u043c\u044b \u043c\u043e\u0433\u043b\u0438 \u043f\u043e\u0441\u043c\u043e\u0442\u0440\u0435\u0442\u044c, \u0447\u0442\u043e \u043e\u043d\u0438 \u0432\u043e\u0437\u0432\u0440\u0430\u0449\u0430\u044e\u0442 \u043f\u0435\u0440\u0435\u0434 \u0442\u0435\u043c, \u043a\u0430\u043a \u0438\u0445 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442 \u0431\u0443\u0434\u0435\u0442 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0432 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0435. \u041a\u043e\u0440\u0440\u0435\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0435 \u0436\u0435 \u043f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441\u044b \u0441\u0441\u044b\u043b\u0430\u044e\u0442\u0441\u044f \u043d\u0430 \u043e\u0434\u0438\u043d \u0438\u043b\u0438 \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u043e \u0441\u0442\u043e\u043b\u0431\u0446\u043e\u0432 \u043e\u0441\u043d\u043e\u0432\u043d\u043e\u0433\u043e \u0437\u0430\u043f\u0440\u043e\u0441\u0430<\/p>\n\n\n\n
        \u041a\u043e\u0440\u0440\u0435\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u044b\u0439 \u043f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441 \u043e\u0442\u043b\u0438\u0447\u0430\u0435\u0442\u0441\u044f \u043e\u0442 \u043d\u0435\u043a\u043e\u0440\u0440\u0435\u043b\u0438\u0440\u043e\u0432\u0430\u043d\u043d\u043e\u0433\u043e \u043f\u043e\u0434\u0437\u0430\u043f\u0440\u043e\u0441\u0430 \u0442\u0435\u043c, \u0447\u0442\u043e \u043e\u043d \u0432\u044b\u043f\u043e\u043b\u043d\u044f\u0435\u0442\u0441\u044f \u043d\u0435 \u043e\u0434\u0438\u043d \u0440\u0430\u0437 \u043f\u0435\u0440\u0435\u0434 \u0432\u044b\u043f\u043e\u043b\u043d\u0435\u043d\u0438\u0435\u043c \u0437\u0430\u043f\u0440\u043e\u0441\u0430, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0439 \u043e\u043d \u0432\u043b\u043e\u0436\u0435\u043d, \u0430 \u0434\u043b\u044f \u043a\u0430\u0436\u0434\u043e\u0439 \u0441\u0442\u0440\u043e\u043a\u0438, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043c\u043e\u0436\u0435\u0442 \u0431\u044b\u0442\u044c \u0432\u043a\u043b\u044e\u0447\u0435\u043d\u0430 \u0432 \u043e\u043a\u043e\u043d\u0447\u0430\u0442\u0435\u043b\u044c\u043d\u044b\u0439 \u0440\u0435\u0437\u0443\u043b\u044c\u0442\u0430\u0442.<\/p>\n\n\n\n
        <\/path><\/path><\/svg><\/span>
        SELECT<\/span> FamilyMembers.member_name,<\/span><\/span>\n(<\/span>SELECT<\/span> <\/span>MAX<\/span>(unit_price) <\/span>FROM<\/span> Payments <\/span>WHERE<\/span> Payments.family_member = FamilyMembers.member_id) <\/span><\/span>\nAS<\/span> good_price<\/span><\/span>\nFROM<\/span> FamilyMembers<\/span><\/span><\/code><\/pre><\/div>\n","protected":false},"excerpt":{"rendered":"
        WHERE — \u043e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 \u0434\u043b\u044f \u043e\u043f\u0440\u0435\u0434\u0435\u043b\u0435\u043d\u0438\u044f \u0443\u0441\u043b\u043e\u0432\u0438\u0439 \u0432\u044b\u0431\u043e\u0440\u043a\u0438 IN — \u041e\u043f\u0435\u0440\u0430\u0442\u043e\u0440 IN \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0441\u043e\u043a\u0440\u0430\u0449\u0435\u043d\u0438\u0435\u043c \u0434\u043b\u044f \u043d\u0435\u0441\u043a\u043e\u043b\u044c\u043a\u0438\u0445 OR \u0443\u0441\u043b\u043e\u0432\u0438\u0439. BETWEEN — \u0432\u044b\u0431\u0438\u0440\u0430\u0435\u0442 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0432 \u0437\u0430\u0434\u0430\u043d\u043d\u043e\u043c \u0434\u0438\u0430\u043f\u0430\u0437\u043e\u043d\u0435. \u042f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u043d\u043a\u043b\u044e\u0437\u0438\u0432\u043d\u044b\u043c: \u043d\u0430\u0447\u0430\u043b\u044c\u043d\u043e\u0435 \u0438 \u043a\u043e\u043d\u0435\u0447\u043d\u043e\u0435 \u0437\u043d\u0430\u0447\u0435\u043d\u0438\u044f \u0432\u043a\u043b\u044e\u0447\u0435\u043d\u044b.  LIKE —…<\/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-576","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=\/wp\/v2\/pages\/576","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=576"}],"version-history":[{"count":35,"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=\/wp\/v2\/pages\/576\/revisions"}],"predecessor-version":[{"id":901,"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=\/wp\/v2\/pages\/576\/revisions\/901"}],"wp:attachment":[{"href":"https:\/\/road-to-heaven.viro35.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}