{"id":27975,"date":"2023-06-24T03:37:32","date_gmt":"2023-06-24T00:07:32","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/replace-employee-id-with-the-unique-identifier-leetcode-mssql-27a7\/"},"modified":"2023-06-24T03:37:32","modified_gmt":"2023-06-24T00:07:32","slug":"replace-employee-id-with-the-unique-identifier-leetcode-mssql-27a7","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/replace-employee-id-with-the-unique-identifier-leetcode-mssql-27a7\/","title":{"rendered":"\u0634\u0646\u0627\u0633\u0647 \u06a9\u0627\u0631\u0645\u0646\u062f \u0631\u0627 \u0628\u0627 \u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631\u0628\u0641\u0631\u062f \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06a9\u0646\u06cc\u062f  LeetCode |  MSSQL"},"content":{"rendered":"<div data-article-id=\"1510747\" id=\"article-body\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter-rtl ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u062a\u063a\u06cc\u06cc\u0631 \u0648\u0636\u0639\u06cc\u062a \u0641\u0647\u0631\u0633\u062a \u0645\u0637\u0627\u0644\u0628\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/nabfollower.com\/blog\/replace-employee-id-with-the-unique-identifier-leetcode-mssql-27a7\/#%D9%85%D8%B4%DA%A9%D9%84\" >\u0645\u0634\u06a9\u0644<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/nabfollower.com\/blog\/replace-employee-id-with-the-unique-identifier-leetcode-mssql-27a7\/#%D8%AA%D9%88%D8%B6%DB%8C%D8%AD\" >\u062a\u0648\u0636\u06cc\u062d<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/nabfollower.com\/blog\/replace-employee-id-with-the-unique-identifier-leetcode-mssql-27a7\/#%D8%B1%D8%A7%D9%87_%D8%AD%D9%84\" >\u0631\u0627\u0647 \u062d\u0644<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/nabfollower.com\/blog\/replace-employee-id-with-the-unique-identifier-leetcode-mssql-27a7\/#%DA%A9%D8%AF_%D9%85%D9%86%D8%A8%D8%B9_1\" >\u06a9\u062f \u0645\u0646\u0628\u0639 1<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/nabfollower.com\/blog\/replace-employee-id-with-the-unique-identifier-leetcode-mssql-27a7\/#%DA%A9%D8%AF_%D9%85%D9%86%D8%A8%D8%B9_2\" >\u06a9\u062f \u0645\u0646\u0628\u0639 2<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/nabfollower.com\/blog\/replace-employee-id-with-the-unique-identifier-leetcode-mssql-27a7\/#%DA%A9%D8%AF_%D9%85%D9%86%D8%A8%D8%B9_3\" >\u06a9\u062f \u0645\u0646\u0628\u0639 3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/nabfollower.com\/blog\/replace-employee-id-with-the-unique-identifier-leetcode-mssql-27a7\/#%DA%A9%D8%AF_%D9%85%D9%86%D8%A8%D8%B9_4\" >\u06a9\u062f \u0645\u0646\u0628\u0639 4<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/nabfollower.com\/blog\/replace-employee-id-with-the-unique-identifier-leetcode-mssql-27a7\/#%D9%86%D8%AA%DB%8C%D8%AC%D9%87\" >\u0646\u062a\u06cc\u062c\u0647<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D9%85%D8%B4%DA%A9%D9%84\"><\/span>\n<p>  \u0645\u0634\u06a9\u0644<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0627\u06cc\u0646 \u0645\u0634\u06a9\u0644 \u0634\u0627\u0645\u0644 \u062f\u0648 \u062c\u062f\u0648\u0644 \u0627\u0633\u062a\u060c <code>Employees<\/code> \u0648 <code>EmployeeUNI<\/code>.<\/p>\n<p><strong>\u062c\u062f\u0648\u0644: \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646<\/strong><\/p>\n<div class=\"table-wrapper-paragraph\">\n<table>\n<thead>\n<tr>\n<th>\u0646\u0627\u0645 \u0633\u062a\u0648\u0646<\/th>\n<th>\u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u0634\u0646\u0627\u0633\u0647<\/td>\n<td>\u0628\u06cc\u0646 \u0627\u0644\u0645\u0644\u0644\u06cc<\/td>\n<\/tr>\n<tr>\n<td>\u0646\u0627\u0645<\/td>\n<td>varchar<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>\u062f\u0631 \u0627\u06cc\u0646 \u062c\u062f\u0648\u0644\u060c <code>id<\/code> \u06a9\u0644\u06cc\u062f \u0627\u0648\u0644\u06cc\u0647 \u0627\u0633\u062a.  \u0647\u0631 \u0631\u062f\u06cc\u0641 \u0634\u0627\u0645\u0644 \u0634\u0646\u0627\u0633\u0647 \u0648 \u0646\u0627\u0645 \u06cc\u06a9 \u06a9\u0627\u0631\u0645\u0646\u062f \u062f\u0631 \u06cc\u06a9 \u0634\u0631\u06a9\u062a \u0627\u0633\u062a.<\/p>\n<p><strong>\u062c\u062f\u0648\u0644: EmployeeUNI<\/strong><\/p>\n<div class=\"table-wrapper-paragraph\">\n<table>\n<thead>\n<tr>\n<th>\u0646\u0627\u0645 \u0633\u062a\u0648\u0646<\/th>\n<th>\u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u0634\u0646\u0627\u0633\u0647<\/td>\n<td>\u0628\u06cc\u0646 \u0627\u0644\u0645\u0644\u0644\u06cc<\/td>\n<\/tr>\n<tr>\n<td>\u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f<\/td>\n<td>\u0628\u06cc\u0646 \u0627\u0644\u0645\u0644\u0644\u06cc<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>\u06a9\u0627\u0645\u067e\u0648\u0632\u06cc\u062a <code>(id, unique_id)<\/code> \u06a9\u0644\u06cc\u062f \u0627\u0635\u0644\u06cc \u0627\u06cc\u0646 \u062c\u062f\u0648\u0644 \u0627\u0633\u062a.  \u0647\u0631 \u0631\u062f\u06cc\u0641 \u0634\u0627\u0645\u0644 \u0634\u0646\u0627\u0633\u0647 \u0648 \u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631\u0628\u0641\u0631\u062f \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u06cc\u06a9 \u06a9\u0627\u0631\u0645\u0646\u062f \u062f\u0631 \u0634\u0631\u06a9\u062a \u0627\u0633\u062a.<\/p>\n<p>\u0648\u0638\u06cc\u0641\u0647 \u0627\u06cc\u0646 \u0627\u0633\u062a \u06a9\u0647 \u06cc\u06a9 \u067e\u0631\u0633 \u0648 \u062c\u0648\u06cc SQL \u0628\u0646\u0648\u06cc\u0633\u06cc\u062f \u062a\u0627 \u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0647\u0631 \u06a9\u0627\u0631\u0628\u0631 \u0631\u0627 \u0646\u0634\u0627\u0646 \u062f\u0647\u062f.  \u0627\u06af\u0631 \u06a9\u0627\u0631\u0628\u0631\u06cc \u06cc\u06a9 \u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0646\u062f\u0627\u0631\u062f\u060c \u0641\u0642\u0637 NULL \u0631\u0627 \u0646\u0634\u0627\u0646 \u062f\u0647\u06cc\u062f.  \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u0645\u06cc \u062a\u0648\u0627\u0646 \u0628\u0647 \u0647\u0631 \u062a\u0631\u062a\u06cc\u0628\u06cc \u0628\u0631\u06af\u0631\u062f\u0627\u0646\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%D8%AA%D9%88%D8%B6%DB%8C%D8%AD\"><\/span>\n<p>  \u062a\u0648\u0636\u06cc\u062d<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0628\u06cc\u0627\u06cc\u06cc\u062f \u062f\u0627\u062f\u0647 \u0647\u0627\u06cc \u0648\u0631\u0648\u062f\u06cc \u0632\u06cc\u0631 \u0631\u0627 \u062f\u0631 \u0646\u0638\u0631 \u0628\u06af\u06cc\u0631\u06cc\u0645:<\/p>\n<p><strong>\u062c\u062f\u0648\u0644 \u06a9\u0627\u0631\u06a9\u0646\u0627\u0646:<\/strong><\/p>\n<div class=\"table-wrapper-paragraph\">\n<table>\n<thead>\n<tr>\n<th>\u0634\u0646\u0627\u0633\u0647<\/th>\n<th>\u0646\u0627\u0645<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>1<\/td>\n<td>\u0622\u0644\u06cc\u0633<\/td>\n<\/tr>\n<tr>\n<td>7<\/td>\n<td>\u0628\u0627\u0628<\/td>\n<\/tr>\n<tr>\n<td>11<\/td>\n<td>\u0645\u06cc\u0631<\/td>\n<\/tr>\n<tr>\n<td>90<\/td>\n<td>\u0648\u06cc\u0646\u0633\u062a\u0648\u0646<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>\u062c\u0627\u0646\u0627\u062a\u0627\u0646<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p><strong>\u062c\u062f\u0648\u0644 EmployeeUNI:<\/strong><\/p>\n<div class=\"table-wrapper-paragraph\">\n<table>\n<thead>\n<tr>\n<th>\u0634\u0646\u0627\u0633\u0647<\/th>\n<th>\u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>3<\/td>\n<td>1<\/td>\n<\/tr>\n<tr>\n<td>11<\/td>\n<td>2<\/td>\n<\/tr>\n<tr>\n<td>90<\/td>\n<td>3<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<p>\u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0627\u0632 <code>Meir<\/code> 2 \u0627\u0633\u062a\u060c <code>Winston<\/code> 3 \u0627\u0633\u062a \u0648 <code>Jonathan<\/code> 1 \u0627\u0633\u062a. <code>Alice<\/code> \u0648 <code>Bob<\/code> \u0634\u0646\u0627\u0633\u0647 \u0647\u0627\u06cc \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0646\u062f\u0627\u0631\u0646\u062f<\/p>\n<p>\u0628\u0646\u0627\u0628\u0631\u0627\u06cc\u0646 \u062e\u0631\u0648\u062c\u06cc \u0645\u0648\u0631\u062f \u0627\u0646\u062a\u0638\u0627\u0631 \u0639\u0628\u0627\u0631\u062a \u0627\u0633\u062a \u0627\u0632:<\/p>\n<div class=\"table-wrapper-paragraph\">\n<table>\n<thead>\n<tr>\n<th>\u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f<\/th>\n<th>\u0646\u0627\u0645<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>\u062e\u0627\u0644\u06cc<\/td>\n<td>\u0622\u0644\u06cc\u0633<\/td>\n<\/tr>\n<tr>\n<td>\u062e\u0627\u0644\u06cc<\/td>\n<td>\u0628\u0627\u0628<\/td>\n<\/tr>\n<tr>\n<td>2<\/td>\n<td>\u0645\u06cc\u0631<\/td>\n<\/tr>\n<tr>\n<td>3<\/td>\n<td>\u0648\u06cc\u0646\u0633\u062a\u0648\u0646<\/td>\n<\/tr>\n<tr>\n<td>1<\/td>\n<td>\u062c\u0627\u0646\u0627\u062a\u0627\u0646<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"%D8%B1%D8%A7%D9%87_%D8%AD%D9%84\"><\/span>\n<p>  \u0631\u0627\u0647 \u062d\u0644<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0631\u0627\u0647 \u0647\u0627\u06cc \u0645\u062e\u062a\u0644\u0641\u06cc \u0628\u0631\u0627\u06cc \u062d\u0644 \u0627\u06cc\u0646 \u0645\u0634\u06a9\u0644 \u0648\u062c\u0648\u062f \u062f\u0627\u0631\u062f.  \u0645\u0627 \u0686\u0647\u0627\u0631 \u0631\u0648\u06cc\u06a9\u0631\u062f \u0645\u062e\u062a\u0644\u0641 \u0631\u0627 \u0645\u0648\u0631\u062f \u0628\u062d\u062b \u0642\u0631\u0627\u0631 \u062e\u0648\u0627\u0647\u06cc\u0645 \u062f\u0627\u062f \u06a9\u0647 \u0627\u0632 \u0627\u0646\u0648\u0627\u0639 \u0645\u062e\u062a\u0644\u0641 \u0639\u0645\u0644\u06cc\u0627\u062a JOIN \u0648 \u0645\u062f\u06cc\u0631\u06cc\u062a NULL \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u0646\u062f.  \u0647\u0631 \u0631\u0648\u0634\u06cc \u0627\u0632 \u0646\u0638\u0631 \u062e\u0648\u0627\u0646\u0627\u06cc\u06cc\u060c \u0645\u0642\u06cc\u0627\u0633 \u067e\u0630\u06cc\u0631\u06cc \u0648 \u0633\u0631\u0639\u062a \u0627\u062c\u0631\u0627 \u0645\u0632\u0627\u06cc\u0627 \u0648 \u0645\u0639\u0627\u06cc\u0628 \u062e\u0627\u0635 \u062e\u0648\u062f \u0631\u0627 \u062f\u0627\u0631\u062f.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"%DA%A9%D8%AF_%D9%85%D9%86%D8%A8%D8%B9_1\"><\/span>\n<p>  \u06a9\u062f \u0645\u0646\u0628\u0639 1<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0631\u0648\u0634 \u0627\u0648\u0644 \u0627\u0632 \u06cc\u06a9 \u0639\u0645\u0644\u06cc\u0627\u062a LEFT JOIN \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f <code>Employees<\/code> \u0628\u0647 <code>EmployeeUNI<\/code> \u0628\u0631 <code>id<\/code>.  \u0627\u06af\u0631 \u06cc\u06a9 \u06a9\u0627\u0631\u0645\u0646\u062f \u06cc\u06a9 \u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631\u0628\u0647\u200c\u0641\u0631\u062f \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f (\u06cc\u0639\u0646\u06cc \u0631\u062f\u06cc\u0641 \u0645\u0631\u0628\u0648\u0637\u0647 \u062f\u0631 \u0622\u0646 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0634\u062a\u0647 \u0628\u0627\u0634\u062f <code>EmployeeUNI<\/code>) <code>ISNULL<\/code> \u062a\u0627\u0628\u0639 \u062c\u0627\u06cc\u06af\u0632\u06cc\u0646 \u06af\u0645\u0634\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f <code>unique_id<\/code> \u0628\u0627 NULL.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>\n    <span class=\"n\">u<\/span><span class=\"p\">.<\/span><span class=\"n\">unique_id<\/span><span class=\"p\">,<\/span>\n    <span class=\"k\">ISNULL<\/span><span class=\"p\">(<\/span><span class=\"n\">e<\/span><span class=\"p\">.<\/span><span class=\"n\">name<\/span><span class=\"p\">,<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">)<\/span> <span class=\"p\">[<\/span><span class=\"n\">name<\/span><span class=\"p\">]<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">Employees<\/span> <span class=\"n\">e<\/span> <span class=\"k\">LEFT<\/span> <span class=\"k\">JOIN<\/span> <span class=\"n\">EmployeeUNI<\/span> <span class=\"n\">u<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">u<\/span><span class=\"p\">.<\/span><span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"n\">e<\/span><span class=\"p\">.<\/span><span class=\"n\">id<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0632\u0645\u0627\u0646 \u0627\u062c\u0631\u0627 \u0628\u0631\u0627\u06cc \u0627\u06cc\u0646 \u0631\u0627\u0647 \u062d\u0644 3010 \u0645\u06cc\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 \u0627\u0633\u062a \u06a9\u0647 5.40 \u062f\u0631\u0635\u062f \u0627\u0632 \u0627\u0631\u0633\u0627\u0644 \u0647\u0627 \u062f\u0631 LeetCode \u0631\u0627 \u0634\u06a9\u0633\u062a \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<p><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%DA%A9%D8%AF_%D9%85%D9%86%D8%A8%D8%B9_2\"><\/span>\n<p>  \u06a9\u062f \u0645\u0646\u0628\u0639 2<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0631\u0648\u0634 \u062f\u0648\u0645 \u0627\u0632 \u06cc\u06a9 RIGHT JOIN \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u062f <code>EmployeeUNI<\/code> \u0628\u0647 <code>Employees<\/code> \u0628\u0631 <code>id<\/code>.  \u0631\u0627 <code>ISNULL<\/code> \u0627\u0632 \u062a\u0627\u0628\u0639 \u0628\u0631\u0627\u06cc \u0631\u0633\u06cc\u062f\u06af\u06cc \u0628\u0647 \u0646\u0627\u0645\u200c\u0647\u0627\u06cc \u06af\u0645\u0634\u062f\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u0634\u0648\u062f \u06a9\u0647 \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u062f\u0631 \u0627\u06cc\u0646 \u0635\u0648\u0631\u062a \u0644\u0627\u0632\u0645 \u0646\u0628\u0627\u0634\u062f <code>Employees<\/code> \u06a9\u0627\u0645\u0644 \u0627\u0633\u062a (\u06cc\u0639\u0646\u06cc \u0647\u0645\u0647 \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u0634\u0627\u0645\u0644 <code>Employees<\/code> \u062c\u062f\u0648\u0644).<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>\n    <span class=\"n\">u<\/span><span class=\"p\">.<\/span><span class=\"n\">unique_id<\/span><span class=\"p\">,<\/span>\n    <span class=\"k\">ISNULL<\/span><span class=\"p\">(<\/span><span class=\"n\">e<\/span><span class=\"p\">.<\/span><span class=\"n\">name<\/span><span class=\"p\">,<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">)<\/span> <span class=\"p\">[<\/span><span class=\"n\">name<\/span><span class=\"p\">]<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">EmployeeUNI<\/span> <span class=\"n\">u<\/span> <span class=\"k\">RIGHT<\/span> <span class=\"k\">JOIN<\/span> <span class=\"n\">Employees<\/span> <span class=\"n\">e<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">u<\/span><span class=\"p\">.<\/span><span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"n\">e<\/span><span class=\"p\">.<\/span><span class=\"n\">id<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0631\u0627\u0647 \u062d\u0644 \u0633\u0631\u06cc\u0639\u062a\u0631 \u0627\u0632 \u0631\u0627\u0647 \u062d\u0644 \u0642\u0628\u0644\u06cc \u0628\u0627 \u0632\u0645\u0627\u0646 \u0627\u062c\u0631\u0627 2277 \u0645\u06cc\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 \u0639\u0645\u0644 \u0645\u06cc \u06a9\u0646\u062f \u0648 26.40 \u062f\u0631\u0635\u062f \u0627\u0632 \u0627\u0631\u0633\u0627\u0644 \u0647\u0627 \u062f\u0631 LeetCode \u0631\u0627 \u0634\u06a9\u0633\u062a \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/06\/1687565252_846_\u0634\u0646\u0627\u0633\u0647-\u06a9\u0627\u0631\u0645\u0646\u062f-\u0631\u0627-\u0628\u0627-\u0634\u0646\u0627\u0633\u0647-\u0645\u0646\u062d\u0635\u0631\u0628\u0641\u0631\u062f-\u062c\u0627\u06cc\u06af\u0632\u06cc\u0646-\u06a9\u0646\u06cc\u062f-LeetCode.png\" alt=\"s2\" loading=\"lazy\" width=\"800\" height=\"292\" title=\"\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%DA%A9%D8%AF_%D9%85%D9%86%D8%A8%D8%B9_3\"><\/span>\n<p>  \u06a9\u062f \u0645\u0646\u0628\u0639 3<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0631\u0648\u06cc\u06a9\u0631\u062f \u0633\u0648\u0645 \u0627\u0632 \u06cc\u06a9 \u0639\u0645\u0644\u06cc\u0627\u062a LEFT JOIN \u0645\u0634\u0627\u0628\u0647 \u0627\u0648\u0644\u06cc\u0646 \u0645\u0648\u0631\u062f \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc\u200c\u06a9\u0646\u062f\u060c \u0627\u0645\u0627 \u0622\u0646 \u0631\u0627 \u062d\u0630\u0641 \u0645\u06cc\u200c\u06a9\u0646\u062f <code>ISNULL<\/code> \u0639\u0645\u0644\u06a9\u0631\u062f\u060c \u0628\u0627 \u0627\u06cc\u0646 \u0641\u0631\u0636 <code>Employees<\/code> \u06a9\u0627\u0645\u0644 \u0627\u0633\u062a.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>\n    <span class=\"n\">eu<\/span><span class=\"p\">.<\/span><span class=\"n\">unique_id<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">e<\/span><span class=\"p\">.<\/span><span class=\"n\">name<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">Employees<\/span> <span class=\"n\">e<\/span> <span class=\"k\">LEFT<\/span> <span class=\"k\">JOIN<\/span> <span class=\"n\">EmployeeUNI<\/span> <span class=\"n\">eu<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">e<\/span><span class=\"p\">.<\/span><span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"n\">eu<\/span><span class=\"p\">.<\/span><span class=\"n\">id<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0631\u0627\u0647 \u062d\u0644 \u062f\u0627\u0631\u0627\u06cc \u0632\u0645\u0627\u0646 \u0627\u062c\u0631\u0627 3314 \u0645\u06cc\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 \u0627\u0633\u062a \u06a9\u0647 5.2 \u062f\u0631\u0635\u062f \u0627\u0632 \u0645\u0648\u0627\u0631\u062f \u0627\u0631\u0633\u0627\u0644\u06cc \u062f\u0631 LeetCode \u0631\u0627 \u0634\u06a9\u0633\u062a \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/06\/1687565252_872_\u0634\u0646\u0627\u0633\u0647-\u06a9\u0627\u0631\u0645\u0646\u062f-\u0631\u0627-\u0628\u0627-\u0634\u0646\u0627\u0633\u0647-\u0645\u0646\u062d\u0635\u0631\u0628\u0641\u0631\u062f-\u062c\u0627\u06cc\u06af\u0632\u06cc\u0646-\u06a9\u0646\u06cc\u062f-LeetCode.png\" alt=\"s3\" loading=\"lazy\" width=\"800\" height=\"295\" title=\"\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"%DA%A9%D8%AF_%D9%85%D9%86%D8%A8%D8%B9_4\"><\/span>\n<p>  \u06a9\u062f \u0645\u0646\u0628\u0639 4<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0631\u0627\u0647 \u062d\u0644 \u0686\u0647\u0627\u0631\u0645 \u0645\u0634\u0627\u0628\u0647 \u0631\u0648\u06cc\u06a9\u0631\u062f \u062f\u0648\u0645 \u0627\u0633\u062a \u0627\u0645\u0627 \u0628\u062f\u0648\u0646 \u0622\u0646 <code>ISNULL<\/code> \u0639\u0645\u0644\u06a9\u0631\u062f\u060c \u0628\u0627 \u0627\u06cc\u0646 \u0641\u0631\u0636 <code>Employees<\/code> \u06a9\u0627\u0645\u0644 \u0627\u0633\u062a.<\/p>\n<div class=\"highlight js-code-highlight\">\n<pre class=\"highlight sql\"><code><span class=\"k\">SELECT<\/span>\n    <span class=\"n\">u<\/span><span class=\"p\">.<\/span><span class=\"n\">unique_id<\/span><span class=\"p\">,<\/span>\n    <span class=\"n\">e<\/span><span class=\"p\">.<\/span><span class=\"n\">name<\/span>\n<span class=\"k\">FROM<\/span> <span class=\"n\">EmployeeUNI<\/span> <span class=\"n\">u<\/span> <span class=\"k\">RIGHT<\/span> <span class=\"k\">JOIN<\/span> <span class=\"n\">Employees<\/span> <span class=\"n\">e<\/span> <span class=\"k\">ON<\/span> <span class=\"n\">u<\/span><span class=\"p\">.<\/span><span class=\"n\">id<\/span> <span class=\"o\">=<\/span> <span class=\"n\">e<\/span><span class=\"p\">.<\/span><span class=\"n\">id<\/span>\n<\/code><\/pre>\n<div class=\"highlight__panel js-actions-panel\">\n<div class=\"highlight__panel-action js-fullscreen-code-action\">\n    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-on\"><title>\u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M16 3h6v6h-2V5h-4V3zM2 3h6v2H4v4H2V3zm18 16v-4h2v6h-6v-2h4zM4 19h4v2H2v-6h2v4z\"\/>\n<\/svg><\/p>\n<p>    <svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" class=\"highlight-action crayons-icon highlight-action--fullscreen-off\"><title>\u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    <path d=\"M18 7h4v2h-6V3h2v4zM8 9H2V7h4V3h2v6zm10 8v4h-2v-6h6v2h-4zM8 15v6H6v-4H2v-2h6z\"\/>\n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n<p>\u0627\u06cc\u0646 \u0631\u0627\u0647 \u062d\u0644 \u062f\u0627\u0631\u0627\u06cc \u0632\u0645\u0627\u0646 \u0627\u062c\u0631\u0627 2093 \u0645\u06cc\u0644\u06cc \u062b\u0627\u0646\u06cc\u0647 \u0627\u0633\u062a \u06a9\u0647 43.45 \u062f\u0631\u0635\u062f \u0627\u0632 \u0645\u0648\u0627\u0631\u062f \u0627\u0631\u0633\u0627\u0644\u06cc \u062f\u0631 LeetCode \u0631\u0627 \u0634\u06a9\u0633\u062a \u0645\u06cc \u062f\u0647\u062f.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/06\/1687565252_777_\u0634\u0646\u0627\u0633\u0647-\u06a9\u0627\u0631\u0645\u0646\u062f-\u0631\u0627-\u0628\u0627-\u0634\u0646\u0627\u0633\u0647-\u0645\u0646\u062d\u0635\u0631\u0628\u0641\u0631\u062f-\u062c\u0627\u06cc\u06af\u0632\u06cc\u0646-\u06a9\u0646\u06cc\u062f-LeetCode.png\" alt=\"s4\" loading=\"lazy\" width=\"800\" height=\"294\" title=\"\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"%D9%86%D8%AA%DB%8C%D8%AC%D9%87\"><\/span>\n<p>  \u0646\u062a\u06cc\u062c\u0647<br \/>\n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0647\u0631 \u06cc\u06a9 \u0627\u0632 \u0631\u0627\u0647 \u062d\u0644 \u0647\u0627\u06cc \u0628\u0627\u0644\u0627 \u067e\u0627\u0633\u062e \u0645\u0639\u062a\u0628\u0631\u06cc \u0628\u0647 \u0645\u0634\u06a9\u0644 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u062f\u060c \u0627\u0644\u0628\u062a\u0647 \u0628\u0627 \u0646\u062a\u0627\u06cc\u062c \u0639\u0645\u0644\u06a9\u0631\u062f \u0645\u062a\u0641\u0627\u0648\u062a \u062f\u0631 LeetCode. <\/p>\n<p>\u0628\u0627 \u062a\u0648\u062c\u0647 \u0628\u0647 \u0645\u0639\u06cc\u0627\u0631\u0647\u0627\u06cc LeetCode\u060c \u0631\u0627\u0647 \u062d\u0644 \u0686\u0647\u0627\u0631\u0645 (\u06a9\u062f \u0645\u0646\u0628\u0639 4) \u0628\u0647\u062a\u0631\u06cc\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f \u0631\u0627 \u062f\u0627\u0631\u062f\u060c \u0633\u067e\u0633 \u0631\u0627\u0647 \u062d\u0644 \u062f\u0648\u0645 (\u06a9\u062f \u0645\u0646\u0628\u0639 2)\u060c \u0633\u067e\u0633 \u0631\u0627\u0647 \u062d\u0644 \u0627\u0648\u0644 (\u06a9\u062f \u0645\u0646\u0628\u0639 1) \u200b\u200b\u0648 \u062f\u0631 \u0646\u0647\u0627\u06cc\u062a \u0631\u0627\u0647 \u062d\u0644 \u0633\u0648\u0645 (\u06a9\u062f \u0645\u0646\u0628\u0639 3) \u0642\u0631\u0627\u0631 \u0645\u06cc \u06af\u06cc\u0631\u062f. .  \u0628\u0627 \u0627\u06cc\u0646 \u062d\u0627\u0644\u060c \u062a\u0648\u062c\u0647 \u0628\u0647 \u0627\u06cc\u0646 \u0646\u06a9\u062a\u0647 \u0645\u0647\u0645 \u0627\u0633\u062a \u06a9\u0647 \u062f\u0631 \u0633\u0646\u0627\u0631\u06cc\u0648\u0647\u0627\u06cc \u062f\u0646\u06cc\u0627\u06cc \u0648\u0627\u0642\u0639\u06cc\u060c \u0639\u0645\u0644\u06a9\u0631\u062f \u0645\u0645\u06a9\u0646 \u0627\u0633\u062a \u0628\u0631 \u0627\u0633\u0627\u0633 RDBMS \u062e\u0627\u0635 \u0648 \u0633\u0627\u062e\u062a\u0627\u0631 \u067e\u0627\u06cc\u06af\u0627\u0647 \u062f\u0627\u062f\u0647 \u0648 \u062d\u062c\u0645 \u062f\u0627\u062f\u0647 \u0645\u062a\u0641\u0627\u0648\u062a \u0628\u0627\u0634\u062f.<\/p>\n<p>\u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u0645\u0634\u06a9\u0644 \u0627\u0635\u0644\u06cc \u0631\u0627 \u062f\u0631 LeetCode \u067e\u06cc\u062f\u0627 \u06a9\u0646\u06cc\u062f.<\/p>\n<p>\u0628\u0631\u0627\u06cc \u0631\u0627\u0647\u200c\u062d\u0644\u200c\u0647\u0627\u06cc \u0631\u0648\u0634\u0646\u200c\u062a\u0631 \u0648 \u0645\u062d\u062a\u0648\u0627\u06cc \u0645\u0631\u062a\u0628\u0637 \u0628\u0627 \u0641\u0646\u0627\u0648\u0631\u06cc\u060c \u062f\u0631 \u0635\u0641\u062d\u0647 Beacons \u0645\u0646 \u0628\u0627 \u0645\u0646 \u062f\u0631 \u0627\u0631\u062a\u0628\u0627\u0637 \u0628\u0627\u0634\u06cc\u062f.<\/p>\n<div class=\"crayons-card c-embed text-styles text-styles--secondary\">\n<div class=\"c-embed__cover\">\n<p>          <img decoding=\"async\" alt=\"\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/05\/1684443382_169_\u062f\u0631\u0622\u0645\u062f-\u06a9\u0627\u0631\u06a9\u0646\u0627\u0646-\u0628\u06cc\u0634\u062a\u0631-\u0627\u0632-\u0645\u062f\u06cc\u0631\u0627\u0646\u0634\u0627\u0646-LeetCode-MSSQL.png\" height=\"200\" loading=\"lazy\" class=\"m-0\" width=\"200\" title=\"\"><\/p><\/div>\n<div class=\"c-embed__body\">\n<p class=\"truncate-at-3\">\n<p>          @ranggakd |  \u062e\u0644\u0627\u0635\u0647 \u062e\u0644\u0627\u0635\u0647 \u062c\u0632\u0626\u06cc\u0627\u062a \u0645\u0631\u06a9\u0632 \u0627\u0648\u0647 \u0633\u0644\u0627\u0645\u060c \u0645\u0646 \u06cc\u06a9 \u0628\u0631\u0646\u0627\u0645\u0647 \u0646\u0648\u06cc\u0633 \u0647\u0633\u062a\u0645.\n        <\/p>\n<div class=\"color-secondary fs-s flex items-center\">\n          <img decoding=\"async\" alt=\"\u0641\u0627\u0648\u06cc\u06a9\u0648\u0646\" class=\"c-embed__favicon m-0 mr-2 radius-0\" src=\"https:\/\/nabfollower.com\/blog\/wp-content\/uploads\/2023\/05\/\u062f\u0631\u0622\u0645\u062f-\u06a9\u0627\u0631\u06a9\u0646\u0627\u0646-\u0628\u06cc\u0634\u062a\u0631-\u0627\u0632-\u0645\u062f\u06cc\u0631\u0627\u0646\u0634\u0627\u0646-LeetCode-MSSQL.ico.png\" loading=\"lazy\" width=\"48\" height=\"48\" title=\"\"><br \/>\n        beacons.ai\n      <\/div>\n<\/p><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u0645\u0634\u06a9\u0644 \u0627\u06cc\u0646 \u0645\u0634\u06a9\u0644 \u0634\u0627\u0645\u0644 \u062f\u0648 \u062c\u062f\u0648\u0644 \u0627\u0633\u062a\u060c Employees \u0648 EmployeeUNI. \u062c\u062f\u0648\u0644: \u06a9\u0627\u0631\u0645\u0646\u062f\u0627\u0646 \u0646\u0627\u0645 \u0633\u062a\u0648\u0646 \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f \u0634\u0646\u0627\u0633\u0647 \u0628\u06cc\u0646 \u0627\u0644\u0645\u0644\u0644\u06cc \u0646\u0627\u0645 varchar \u062f\u0631 \u0627\u06cc\u0646 \u062c\u062f\u0648\u0644\u060c id \u06a9\u0644\u06cc\u062f \u0627\u0648\u0644\u06cc\u0647 \u0627\u0633\u062a. \u0647\u0631 \u0631\u062f\u06cc\u0641 \u0634\u0627\u0645\u0644 \u0634\u0646\u0627\u0633\u0647 \u0648 \u0646\u0627\u0645 \u06cc\u06a9 \u06a9\u0627\u0631\u0645\u0646\u062f \u062f\u0631 \u06cc\u06a9 \u0634\u0631\u06a9\u062a \u0627\u0633\u062a. \u062c\u062f\u0648\u0644: EmployeeUNI \u0646\u0627\u0645 \u0633\u062a\u0648\u0646 \u062a\u0627\u06cc\u067e \u06a9\u0646\u06cc\u062f \u0634\u0646\u0627\u0633\u0647 \u0628\u06cc\u0646 \u0627\u0644\u0645\u0644\u0644\u06cc \u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0628\u06cc\u0646 \u0627\u0644\u0645\u0644\u0644\u06cc &hellip;<\/p>\n","protected":false},"author":2,"featured_media":27976,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-27975","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dev"],"_links":{"self":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/27975","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/comments?post=27975"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/27975\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/27976"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=27975"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=27975"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=27975"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}