{"id":90436,"date":"2024-12-30T00:34:43","date_gmt":"2024-12-29T21:04:43","guid":{"rendered":"https:\/\/nabfollower.com\/blog\/%d8%a8%d8%b1%d8%b1%d8%b3%db%8c-%d8%b3%d8%b1%db%8c%d8%b9-%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d9%be%d9%86%d8%ac%d8%b1%d9%87-sql-%d8%a8%d8%a7-%d9%85%d8%ab%d8%a7%d9%84\/"},"modified":"2024-12-30T00:34:43","modified_gmt":"2024-12-29T21:04:43","slug":"%d8%a8%d8%b1%d8%b1%d8%b3%db%8c-%d8%b3%d8%b1%db%8c%d8%b9-%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d9%be%d9%86%d8%ac%d8%b1%d9%87-sql-%d8%a8%d8%a7-%d9%85%d8%ab%d8%a7%d9%84","status":"publish","type":"post","link":"https:\/\/nabfollower.com\/blog\/%d8%a8%d8%b1%d8%b1%d8%b3%db%8c-%d8%b3%d8%b1%db%8c%d8%b9-%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d9%be%d9%86%d8%ac%d8%b1%d9%87-sql-%d8%a8%d8%a7-%d9%85%d8%ab%d8%a7%d9%84\/","title":{"rendered":"\u0628\u0631\u0631\u0633\u06cc \u0633\u0631\u06cc\u0639 \u062a\u0648\u0627\u0628\u0639 \u067e\u0646\u062c\u0631\u0647 SQL \u0628\u0627 \u0645\u062b\u0627\u0644"},"content":{"rendered":"
\n

\u062a\u0648\u0627\u0628\u0639 \u067e\u0646\u062c\u0631\u0647 \u06cc\u06a9 \u0648\u06cc\u0698\u06af\u06cc \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u062f\u0631 SQL \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u06cc \u0627\u0632 \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0631\u062f\u06cc\u0641 \u0641\u0639\u0644\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f. \u0628\u0631\u062e\u0644\u0627\u0641 \u062a\u0648\u0627\u0628\u0639 \u062c\u0645\u0639\u060c \u062a\u0648\u0627\u0628\u0639 \u067e\u0646\u062c\u0631\u0647 \u0631\u062f\u06cc\u0641 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u062e\u0631\u0648\u062c\u06cc \u06af\u0631\u0648\u0647 \u0628\u0646\u062f\u06cc \u0646\u0645\u06cc \u06a9\u0646\u0646\u062f. \u0622\u0646\u0647\u0627 \u06cc\u06a9 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0631\u062f\u06cc\u0641 \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u0632\u0645\u06cc\u0646\u0647 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u062d\u0641\u0638 \u0645\u06cc \u06a9\u0646\u0646\u062f\u060c \u0628\u0631\u0645\u06cc \u06af\u0631\u062f\u0627\u0646\u0646\u062f.<\/p>\n

\u062f\u0631 \u0627\u06cc\u0646 \u0645\u0642\u0627\u0644\u0647\u060c \u0645\u0627 \u0628\u0631\u062e\u06cc \u0627\u0632 \u062a\u0648\u0627\u0628\u0639 \u0631\u0627\u06cc\u062c \u067e\u0646\u062c\u0631\u0647 SQL \u0631\u0627 \u0628\u0631\u0631\u0633\u06cc \u062e\u0648\u0627\u0647\u06cc\u0645 \u06a9\u0631\u062f (ROW_NUMBER()<\/code>\u060c RANK()<\/code>\u060c DENSE_RANK()<\/code>\u060c NTILE()<\/code>\u060c LEAD()<\/code>\u060c \u0648 LAG()<\/code>) \u0628\u0627 \u0645\u062b\u0627\u0644.<\/p>\n

\u0645\u0627 \u0627\u0632 \u062c\u062f\u0648\u0644 \u0641\u0631\u0648\u0634 \u0632\u06cc\u0631 \u0628\u0631\u0627\u06cc \u0646\u0634\u0627\u0646 \u062f\u0627\u062f\u0646 \u0639\u0645\u0644\u06a9\u0631\u062f\u0647\u0627\u06cc \u067e\u0646\u062c\u0631\u0647 \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u06a9\u0646\u06cc\u0645:<\/p>\n

\n\n\n\n\n\n\n\n\n\n\n\n\n
\u0634\u0646\u0627\u0633\u0647 \u0641\u0631\u0648\u0634<\/th>\n\u0634\u0646\u0627\u0633\u0647 \u0645\u0634\u062a\u0631\u06cc<\/th>\n\u0645\u062d\u0635\u0648\u0644<\/th>\n\u0645\u0646\u0637\u0642\u0647<\/th>\n\u0645\u0642\u062f\u0627\u0631<\/th>\n\u062a\u0627\u0631\u06cc\u062e \u0641\u0631\u0648\u0634<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\n101<\/td>\n\u0644\u067e \u062a\u0627\u067e<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n1200<\/td>\n05\/01\/2023<\/td>\n<\/tr>\n
2<\/td>\n102<\/td>\n\u062a\u0628\u0644\u062a<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n800<\/td>\n15-02-2023<\/td>\n<\/tr>\n
3<\/td>\n103<\/td>\n\u062a\u0644\u0641\u0646<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n800<\/td>\n2023-03-10<\/td>\n<\/tr>\n
4<\/td>\n104<\/td>\n\u062a\u0628\u0644\u062a<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n500<\/td>\n01-04-2023<\/td>\n<\/tr>\n
5<\/td>\n105<\/td>\n\u0644\u067e \u062a\u0627\u067e<\/td>\n\u062c\u0646\u0648\u0628<\/td>\n1300<\/td>\n05-05-2023<\/td>\n<\/tr>\n
6<\/td>\n106<\/td>\n\u062a\u0628\u0644\u062a<\/td>\n\u062c\u0646\u0648\u0628<\/td>\n700<\/td>\n2023-06-20<\/td>\n<\/tr>\n
7<\/td>\n107<\/td>\n\u062a\u0644\u0641\u0646<\/td>\n\u063a\u0631\u0628<\/td>\n900<\/td>\n15-07-2023<\/td>\n<\/tr>\n
8<\/td>\n108<\/td>\n\u0644\u067e \u062a\u0627\u067e<\/td>\n\u0634\u0631\u0642<\/td>\n1300<\/td>\n10-08-2023<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

\u062a\u0627\u0628\u0639 ROW_NUMBER() \u06cc\u06a9 \u0639\u062f\u062f \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0628\u0647 \u0647\u0631 \u0633\u0637\u0631 \u062f\u0631 \u06cc\u06a9 \u067e\u0627\u0631\u062a\u06cc\u0634\u0646 \u0627\u062e\u062a\u0635\u0627\u0635 \u0645\u06cc \u062f\u0647\u062f \u06a9\u0647 \u062a\u0648\u0633\u0637 \u06cc\u06a9 \u0633\u062a\u0648\u0646 \u0645\u0634\u062e\u0635 \u0645\u0631\u062a\u0628 \u0634\u062f\u0647 \u0627\u0633\u062a.<\/p>\n

\u0648\u0638\u06cc\u0641\u0647<\/strong>: \u06cc\u06a9 \u0634\u0645\u0627\u0631\u0647 \u0631\u062f\u06cc\u0641 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0628\u0647 \u0647\u0631 \u0641\u0631\u0648\u0634 \u062f\u0631 \u06cc\u06a9 \u0645\u0646\u0637\u0642\u0647 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0645\u0628\u0644\u063a \u0641\u0631\u0648\u0634 (\u0628\u06cc\u0634\u062a\u0631\u06cc\u0646 \u0628\u0647 \u06a9\u0645\u062a\u0631\u06cc\u0646) \u0627\u062e\u062a\u0635\u0627\u0635 \u062f\u0647\u06cc\u062f.<\/p>\n

\n
SELECT<\/span> SalesID<\/span>,<\/span> Region<\/span>,<\/span> Amount<\/span>,<\/span>\n       ROW_NUMBER<\/span>()<\/span> OVER<\/span> (<\/span>PARTITION<\/span> BY<\/span> Region<\/span> ORDER<\/span> BY<\/span> Amount<\/span> DESC<\/span>)<\/span> AS<\/span> RowNum<\/span>\nFROM<\/span> Sales<\/span>;<\/span>\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\u0646\u062a\u06cc\u062c\u0647<\/strong>:<\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n
\u0634\u0646\u0627\u0633\u0647 \u0641\u0631\u0648\u0634<\/th>\n\u0645\u0646\u0637\u0642\u0647<\/th>\n\u0645\u0642\u062f\u0627\u0631<\/th>\n\u062a\u0639\u062f\u0627\u062f \u0631\u062f\u06cc\u0641<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n1200<\/td>\n1<\/td>\n<\/tr>\n
2<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n800<\/td>\n2<\/td>\n<\/tr>\n
3<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n800<\/td>\n3<\/td>\n<\/tr>\n
4<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n500<\/td>\n4<\/td>\n<\/tr>\n
5<\/td>\n\u062c\u0646\u0648\u0628<\/td>\n1300<\/td>\n1<\/td>\n<\/tr>\n
6<\/td>\n\u062c\u0646\u0648\u0628<\/td>\n700<\/td>\n2<\/td>\n<\/tr>\n
7<\/td>\n\u063a\u0631\u0628<\/td>\n900<\/td>\n1<\/td>\n<\/tr>\n
8<\/td>\n\u0634\u0631\u0642<\/td>\n1300<\/td>\n1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\u062a\u0627\u0628\u0639 RANK() \u06cc\u06a9 \u0631\u062a\u0628\u0647 \u0628\u0647 \u0647\u0631 \u0631\u062f\u06cc\u0641 \u062f\u0631 \u06cc\u06a9 \u067e\u0627\u0631\u062a\u06cc\u0634\u0646 \u0627\u062e\u062a\u0635\u0627\u0635 \u0645\u06cc \u062f\u0647\u062f. \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc\u06cc \u0628\u0627 \u0645\u0642\u0627\u062f\u06cc\u0631 \u06cc\u06a9\u0633\u0627\u0646 \u0631\u062a\u0628\u0647 \u06cc\u06a9\u0633\u0627\u0646\u06cc \u0631\u0627 \u062f\u0631\u06cc\u0627\u0641\u062a \u0645\u06cc \u06a9\u0646\u0646\u062f \u0648 \u0631\u062a\u0628\u0647 \u0628\u0639\u062f\u06cc \u062d\u0630\u0641 \u0645\u06cc \u0634\u0648\u062f.<\/p>\n
\u0648\u0638\u06cc\u0641\u0647<\/strong>: \u0631\u062a\u0628\u0647 \u0628\u0646\u062f\u06cc \u0641\u0631\u0648\u0634 \u062f\u0631 \u0647\u0631 \u0645\u0646\u0637\u0642\u0647 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0645\u0642\u062f\u0627\u0631 (\u0628\u0627\u0644\u0627\u062a\u0631\u06cc\u0646 \u0628\u0647 \u06a9\u0645\u062a\u0631\u06cc\u0646).<\/p>\n
\n
SELECT<\/span> SalesID<\/span>,<\/span> Region<\/span>,<\/span> Amount<\/span>,<\/span>\n       RANK<\/span>()<\/span> OVER<\/span> (<\/span>PARTITION<\/span> BY<\/span> Region<\/span> ORDER<\/span> BY<\/span> Amount<\/span> DESC<\/span>)<\/span> AS<\/span> Rank<\/span>\nFROM<\/span> Sales<\/span>;<\/span>\n<\/code><\/pre>\n
\n
\n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
    \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
\u0646\u062a\u06cc\u062c\u0647<\/strong>:<\/p>\n
\n\n\n\n\n\n\n\n\n\n\n\n\n
\u0634\u0646\u0627\u0633\u0647 \u0641\u0631\u0648\u0634<\/th>\n\u0645\u0646\u0637\u0642\u0647<\/th>\n\u0645\u0642\u062f\u0627\u0631<\/th>\n\u0631\u062a\u0628\u0647<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n1200<\/td>\n1<\/td>\n<\/tr>\n
2<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n800<\/td>\n2<\/td>\n<\/tr>\n
3<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n800<\/td>\n2<\/td>\n<\/tr>\n
4<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n500<\/td>\n4<\/td>\n<\/tr>\n
5<\/td>\n\u062c\u0646\u0648\u0628<\/td>\n1300<\/td>\n1<\/td>\n<\/tr>\n
6<\/td>\n\u062c\u0646\u0648\u0628<\/td>\n700<\/td>\n2<\/td>\n<\/tr>\n
7<\/td>\n\u063a\u0631\u0628<\/td>\n900<\/td>\n1<\/td>\n<\/tr>\n
8<\/td>\n\u0634\u0631\u0642<\/td>\n1300<\/td>\n1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
\u0648\u06cc\u0698\u06af\u06cc \u06a9\u0644\u06cc\u062f\u06cc<\/strong>:<\/p>\n
    \n
  • \u0628\u0631\u0627\u06cc \u0645\u0646\u0637\u0642\u0647 \u0634\u0645\u0627\u0644\u060c \u0647\u0631 \u062f\u0648 Amount = 800 \u0631\u062f\u06cc\u0641 \u0631\u062a\u0628\u0647 2 \u0631\u0627 \u0628\u0647 \u0627\u0634\u062a\u0631\u0627\u06a9 \u0645\u06cc \u06af\u0630\u0627\u0631\u0646\u062f.<\/li>\n
  • \u0631\u062a\u0628\u0647 \u0628\u0639\u062f\u06cc \u062d\u0630\u0641 \u0645\u06cc \u0634\u0648\u062f (\u06cc\u0639\u0646\u06cc \u0631\u062a\u0628\u0647 3 \u0648\u062c\u0648\u062f \u0646\u062f\u0627\u0631\u062f) \u0648 \u0628\u0647 4 \u0645\u06cc \u067e\u0631\u062f. # 3. DENSE_RANK()<\/li>\n<\/ul>\n
    \u062a\u0627\u0628\u0639 DENSE_RANK() \u0631\u062a\u0628\u0647 \u0647\u0627\u06cc\u06cc \u0645\u0627\u0646\u0646\u062f RANK() \u0631\u0627 \u0627\u062e\u062a\u0635\u0627\u0635 \u0645\u06cc \u062f\u0647\u062f\u060c \u0627\u0645\u0627 \u0627\u0632 \u0631\u062a\u0628\u0647 \u0647\u0627\u06cc \u0628\u0639\u062f \u0627\u0632 \u062a\u0633\u0627\u0648\u06cc \u0647\u0627 \u0646\u0645\u06cc \u06af\u0630\u0631\u062f.<\/p>\n
    \u0648\u0638\u06cc\u0641\u0647<\/strong>: \u0631\u062a\u0628\u0647 \u0647\u0627\u06cc \u0645\u062a\u0631\u0627\u06a9\u0645 \u0631\u0627 \u0628\u0647 \u0645\u06cc\u0632\u0627\u0646 \u0641\u0631\u0648\u0634 \u062f\u0631 \u0647\u0631 \u0645\u0646\u0637\u0642\u0647 \u0627\u062e\u062a\u0635\u0627\u0635 \u062f\u0647\u06cc\u062f (\u0628\u0627\u0644\u0627\u062a\u0631\u06cc\u0646 \u0628\u0647 \u067e\u0627\u06cc\u06cc\u0646 \u062a\u0631\u06cc\u0646).<\/p>\n
    \n
    SELECT<\/span> SalesID<\/span>,<\/span> Region<\/span>,<\/span> Amount<\/span>,<\/span>\n       DENSE_RANK<\/span>()<\/span> OVER<\/span> (<\/span>PARTITION<\/span> BY<\/span> Region<\/span> ORDER<\/span> BY<\/span> Amount<\/span> DESC<\/span>)<\/span> AS<\/span> DenseRank<\/span>\nFROM<\/span> Sales<\/span>;<\/span>\n<\/code><\/pre>\n
    \n
    \n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
        \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
    \u0646\u062a\u06cc\u062c\u0647<\/strong>:<\/p>\n
    \n\n\n\n\n\n\n\n\n\n\n\n\n
    \u0634\u0646\u0627\u0633\u0647 \u0641\u0631\u0648\u0634<\/th>\n\u0645\u0646\u0637\u0642\u0647<\/th>\n\u0645\u0642\u062f\u0627\u0631<\/th>\nDenseRank<\/th>\n<\/tr>\n<\/thead>\n
    1<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n1200<\/td>\n1<\/td>\n<\/tr>\n
    2<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n800<\/td>\n2<\/td>\n<\/tr>\n
    3<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n800<\/td>\n2<\/td>\n<\/tr>\n
    4<\/td>\n\u0634\u0645\u0627\u0644<\/td>\n500<\/td>\n3<\/td>\n<\/tr>\n
    5<\/td>\n\u062c\u0646\u0648\u0628<\/td>\n1300<\/td>\n1<\/td>\n<\/tr>\n
    6<\/td>\n\u062c\u0646\u0648\u0628<\/td>\n700<\/td>\n2<\/td>\n<\/tr>\n
    7<\/td>\n\u063a\u0631\u0628<\/td>\n900<\/td>\n1<\/td>\n<\/tr>\n
    8<\/td>\n\u0634\u0631\u0642<\/td>\n1300<\/td>\n1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
    \u0648\u06cc\u0698\u06af\u06cc \u06a9\u0644\u06cc\u062f\u06cc<\/strong>:<\/p>\n
      \n
    • \u0628\u0631\u0627\u06cc \u0645\u0646\u0637\u0642\u0647 \u0634\u0645\u0627\u0644\u060c \u0647\u0631 \u062f\u0648 Amount = 800 \u0631\u062f\u06cc\u0641 \u0631\u062a\u0628\u0647 2 \u0631\u0627 \u0628\u0647 \u0627\u0634\u062a\u0631\u0627\u06a9 \u0645\u06cc \u06af\u0630\u0627\u0631\u0646\u062f.<\/li>\n
    • \u0631\u062a\u0628\u0647 \u0628\u0639\u062f\u06cc 3 \u0628\u062f\u0648\u0646 \u0631\u062f \u0634\u062f\u0646 \u0627\u0632 \u0631\u062a\u0628\u0647 \u0627\u0633\u062a.<\/li>\n<\/ul>\n
      NTILE () \u0631\u062f\u06cc\u0641 \u0647\u0627 \u0631\u0627 \u0628\u0647 \u062a\u0639\u062f\u0627\u062f \u0645\u0634\u062e\u0635\u06cc \u0627\u0632 \u06af\u0631\u0648\u0647 \u0647\u0627\u06cc \u062a\u0642\u0631\u06cc\u0628\u0627\u064b \u0645\u0633\u0627\u0648\u06cc \u062a\u0642\u0633\u06cc\u0645 \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n
      \u0648\u0638\u06cc\u0641\u0647<\/strong>: \u062a\u0645\u0627\u0645 \u0641\u0631\u0648\u0634 \u0647\u0627 \u0631\u0627 \u0628\u0631 \u0627\u0633\u0627\u0633 \u0645\u0642\u062f\u0627\u0631 \u0628\u0647 \u062a\u0631\u062a\u06cc\u0628 \u0646\u0632\u0648\u0644\u06cc \u0628\u0647 4 \u06af\u0631\u0648\u0647 \u062a\u0642\u0633\u06cc\u0645 \u06a9\u0646\u06cc\u062f.<\/p>\n
      \n
      SELECT<\/span> SalesID<\/span>,<\/span> Amount<\/span>,<\/span>\n       NTILE<\/span>(<\/span>4<\/span>)<\/span> OVER<\/span> (<\/span>ORDER<\/span> BY<\/span> Amount<\/span> DESC<\/span>)<\/span> AS<\/span> Quartile<\/span>\nFROM<\/span> Sales<\/span>;<\/span>\n<\/code><\/pre>\n
      \n
      \n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
          \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
      \u0646\u062a\u06cc\u062c\u0647<\/strong>:<\/p>\n
      \n\n\n\n\n\n\n\n\n\n\n\n\n
      \u0634\u0646\u0627\u0633\u0647 \u0641\u0631\u0648\u0634<\/th>\n\u0645\u0642\u062f\u0627\u0631<\/th>\n\u0686\u0627\u0631\u06a9<\/th>\n<\/tr>\n<\/thead>\n
      5<\/td>\n1300<\/td>\n1<\/td>\n<\/tr>\n
      8<\/td>\n1300<\/td>\n1<\/td>\n<\/tr>\n
      1<\/td>\n1200<\/td>\n2<\/td>\n<\/tr>\n
      7<\/td>\n900<\/td>\n2<\/td>\n<\/tr>\n
      2<\/td>\n800<\/td>\n3<\/td>\n<\/tr>\n
      3<\/td>\n800<\/td>\n3<\/td>\n<\/tr>\n
      4<\/td>\n500<\/td>\n4<\/td>\n<\/tr>\n
      6<\/td>\n700<\/td>\n4<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
      LEAD() \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u0627\u0632 \u0631\u062f\u06cc\u0641 \u0628\u0639\u062f\u06cc \u062f\u0631 \u0647\u0645\u0627\u0646 \u067e\u0627\u0631\u062a\u06cc\u0634\u0646 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n
      \u0648\u0638\u06cc\u0641\u0647<\/strong>: \u0647\u0631 \u0645\u0628\u0644\u063a \u0641\u0631\u0648\u0634 \u0631\u0627 \u0628\u0627 \u0645\u0628\u0644\u063a \u0641\u0631\u0648\u0634 \u0628\u0639\u062f\u06cc \u06a9\u0647 \u062a\u0648\u0633\u0637 SaleDate \u0633\u0641\u0627\u0631\u0634 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0645\u0642\u0627\u06cc\u0633\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n
      \n
      SELECT<\/span> SalesID<\/span>,<\/span> Amount<\/span>,<\/span> \n       LEAD<\/span>(<\/span>Amount<\/span>)<\/span> OVER<\/span> (<\/span>ORDER<\/span> BY<\/span> SaleDate<\/span>)<\/span> AS<\/span> NextAmount<\/span>\nFROM<\/span> Sales<\/span>;<\/span>\n<\/code><\/pre>\n
      \n
      \n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
          \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
      \u0646\u062a\u06cc\u062c\u0647<\/strong>:<\/p>\n
      \n\n\n\n\n\n\n\n\n\n\n\n\n
      \u0634\u0646\u0627\u0633\u0647 \u0641\u0631\u0648\u0634<\/th>\n\u0645\u0642\u062f\u0627\u0631<\/th>\nNextAmount<\/th>\n<\/tr>\n<\/thead>\n
      1<\/td>\n1200<\/td>\n800<\/td>\n<\/tr>\n
      2<\/td>\n800<\/td>\n800<\/td>\n<\/tr>\n
      3<\/td>\n800<\/td>\n500<\/td>\n<\/tr>\n
      4<\/td>\n500<\/td>\n1300<\/td>\n<\/tr>\n
      5<\/td>\n1300<\/td>\n700<\/td>\n<\/tr>\n
      6<\/td>\n700<\/td>\n900<\/td>\n<\/tr>\n
      7<\/td>\n900<\/td>\n1300<\/td>\n<\/tr>\n
      8<\/td>\n1300<\/td>\nNULL<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
      LAG()<\/code>  \u0645\u0642\u062f\u0627\u0631 \u0631\u0627 \u0627\u0632 \u0631\u062f\u06cc\u0641 \u0642\u0628\u0644\u06cc \u062f\u0631 \u0647\u0645\u0627\u0646 \u067e\u0627\u0631\u062a\u06cc\u0634\u0646 \u0628\u0627\u0632\u06cc\u0627\u0628\u06cc \u0645\u06cc \u06a9\u0646\u062f.<\/p>\n
      \u0648\u0638\u06cc\u0641\u0647<\/strong>: \u0647\u0631 \u0645\u0628\u0644\u063a \u0641\u0631\u0648\u0634 \u0631\u0627 \u0628\u0627 \u0645\u0628\u0644\u063a \u0641\u0631\u0648\u0634 \u0642\u0628\u0644\u06cc \u06a9\u0647 \u062a\u0648\u0633\u0637 SaleDate \u0633\u0641\u0627\u0631\u0634 \u062f\u0627\u062f\u0647 \u0634\u062f\u0647 \u0627\u0633\u062a \u0645\u0642\u0627\u06cc\u0633\u0647 \u06a9\u0646\u06cc\u062f.<\/p>\n
      \n
      SELECT<\/span> SalesID<\/span>,<\/span> Amount<\/span>,<\/span> \n       LAG<\/span>(<\/span>Amount<\/span>)<\/span> OVER<\/span> (<\/span>ORDER<\/span> BY<\/span> SaleDate<\/span>)<\/span> AS<\/span> PrevAmount<\/span>\nFROM<\/span> Sales<\/span>;<\/span>\n<\/code><\/pre>\n
      \n
      \n    \u0648\u0627\u0631\u062f \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n
          \u0627\u0632 \u062d\u0627\u0644\u062a \u062a\u0645\u0627\u0645 \u0635\u0641\u062d\u0647 \u062e\u0627\u0631\u062c \u0634\u0648\u06cc\u062f<\/title>\n    \n<\/svg><\/p>\n<\/div>\n<\/div>\n<\/div>\n
      \u0646\u062a\u06cc\u062c\u0647<\/strong>:<\/p>\n
      \n\n\n\n\n\n\n\n\n\n\n\n\n
      \u0634\u0646\u0627\u0633\u0647 \u0641\u0631\u0648\u0634<\/th>\n\u0645\u0642\u062f\u0627\u0631<\/th>\nPrevAmount<\/th>\n<\/tr>\n<\/thead>\n
      1<\/td>\n1200<\/td>\nNULL<\/td>\n<\/tr>\n
      2<\/td>\n800<\/td>\n1200<\/td>\n<\/tr>\n
      3<\/td>\n800<\/td>\n800<\/td>\n<\/tr>\n
      4<\/td>\n500<\/td>\n800<\/td>\n<\/tr>\n
      5<\/td>\n1300<\/td>\n500<\/td>\n<\/tr>\n
      6<\/td>\n700<\/td>\n1300<\/td>\n<\/tr>\n
      7<\/td>\n900<\/td>\n700<\/td>\n<\/tr>\n
      8<\/td>\n1300<\/td>\n900<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n
      \u062a\u0648\u0627\u0628\u0639 \u067e\u0646\u062c\u0631\u0647 SQL \u0645\u0627\u0646\u0646\u062f ROW_NUMBER()\u060c RANK()\u060c DENSE_RANK()\u060c NTILE()\u060c LEAD()\u060c \u0648 LAG() \u0631\u0627\u0647 \u0647\u0627\u06cc \u0642\u062f\u0631\u062a\u0645\u0646\u062f\u06cc \u0628\u0631\u0627\u06cc \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u062f\u0627\u062f\u0647 \u0647\u0627 \u062f\u0631 \u067e\u0627\u0631\u062a\u06cc\u0634\u0646 \u0647\u0627 \u0627\u0631\u0627\u0626\u0647 \u0645\u06cc \u062f\u0647\u0646\u062f.<\/p>\n
      \u0646\u06a9\u0627\u062a \u06a9\u0644\u06cc\u062f\u06cc:<\/strong><\/p>\n
        \n
      • \nROW_NUMBER()<\/code>  \u0628\u0631\u0627\u06cc \u0647\u0631 \u0631\u062f\u06cc\u0641 \u06cc\u06a9 \u0634\u0646\u0627\u0633\u0647 \u0645\u0646\u062d\u0635\u0631 \u0628\u0647 \u0641\u0631\u062f \u0627\u062e\u062a\u0635\u0627\u0635 \u0645\u06cc \u062f\u0647\u062f.<\/li>\n
      • \nRANK()<\/code>  \u0648 DENSE_RANK()<\/code> \u062f\u0631 \u0646\u062d\u0648\u0647 \u0628\u0631\u062e\u0648\u0631\u062f \u0622\u0646\u0647\u0627 \u0628\u0627 \u06a9\u0631\u0627\u0648\u0627\u062a \u0645\u062a\u0641\u0627\u0648\u062a \u0627\u0633\u062a (\u067e\u0631\u0634 \u062f\u0631 \u0645\u0642\u0627\u0628\u0644 \u0639\u062f\u0645 \u062c\u0633\u062a \u0648 \u062e\u06cc\u0632).<\/li>\n
      • \nNTILE()<\/code>  \u0628\u0631\u0627\u06cc \u062a\u0642\u0633\u06cc\u0645 \u0631\u062f\u06cc\u0641 \u0647\u0627 \u0628\u0647 \u06af\u0631\u0648\u0647 \u0647\u0627\u06cc \u0622\u0645\u0627\u0631\u06cc \u0645\u0641\u06cc\u062f \u0627\u0633\u062a.<\/li>\n
      • \nLEAD()<\/code>  \u0648 LAG()<\/code> \u0627\u062c\u0627\u0632\u0647 \u0645\u0642\u0627\u06cc\u0633\u0647 \u0628\u0627 \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u0645\u062c\u0627\u0648\u0631 \u0631\u0627 \u0645\u06cc \u062f\u0647\u062f.<\/li>\n<\/ul>\n
        \u0628\u0627 \u062a\u0633\u0644\u0637 \u0628\u0631 \u0627\u06cc\u0646 \u062a\u0648\u0627\u0628\u0639\u060c \u0645\u06cc \u062a\u0648\u0627\u0646\u06cc\u062f \u062a\u062c\u0632\u06cc\u0647 \u0648 \u062a\u062d\u0644\u06cc\u0644 \u067e\u06cc\u0686\u06cc\u062f\u0647 \u0648 \u0648\u0638\u0627\u06cc\u0641 \u0631\u062a\u0628\u0647 \u0628\u0646\u062f\u06cc \u0631\u0627 \u0628\u0647 \u0637\u0648\u0631 \u0645\u0648\u062b\u0631 \u0627\u0646\u062c\u0627\u0645 \u062f\u0647\u06cc\u062f!<\/p>\n\n
        \n
          \u0628\u06cc\u0634\u062a\u0631 \u06a9\u0627\u0648\u0634 \u06a9\u0646\u06cc\u062f
        \n<\/h2>\n
        \n
        \n        \"\u062a\u0635\u0648\u06cc\u0631\n      <\/div>\n<\/div>\n
        \u0627\u0632 \u0627\u06cc\u0646\u06a9\u0647 \u0648\u0642\u062a \u06af\u0630\u0627\u0634\u062a\u06cc\u062f \u0648 \u0627\u0637\u0644\u0627\u0639\u0627\u062a \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u062f\u0627\u062f\u0647 \u0647\u0627 \u0631\u0627 \u0628\u0627 \u0645\u0646 \u06a9\u0627\u0648\u0634 \u06a9\u0631\u062f\u06cc\u062f \u0645\u062a\u0634\u06a9\u0631\u0645. \u0645\u0646 \u0627\u0632 \u0646\u0627\u0645\u0632\u062f\u06cc \u0634\u0645\u0627 \u0642\u062f\u0631\u062f\u0627\u0646\u06cc \u0645\u06cc \u06a9\u0646\u0645.<\/p>\n
        \ud83d\ude80 \u062f\u0631 \u0644\u06cc\u0646\u06a9\u062f\u06cc\u0646 \u0628\u0627 \u0645\u0646 \u062f\u0631 \u0627\u0631\u062a\u0628\u0627\u0637 \u0628\u0627\u0634\u06cc\u062f\n<\/p>\n
        \"\"<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"
        \u062a\u0648\u0627\u0628\u0639 \u067e\u0646\u062c\u0631\u0647 \u06cc\u06a9 \u0648\u06cc\u0698\u06af\u06cc \u0642\u062f\u0631\u062a\u0645\u0646\u062f \u062f\u0631 SQL \u0647\u0633\u062a\u0646\u062f \u06a9\u0647 \u0628\u0631\u0627\u06cc \u0627\u0646\u062c\u0627\u0645 \u0645\u062d\u0627\u0633\u0628\u0627\u062a \u062f\u0631 \u0645\u062c\u0645\u0648\u0639\u0647 \u0627\u06cc \u0627\u0632 \u0631\u062f\u06cc\u0641 \u0647\u0627\u06cc \u0645\u0631\u0628\u0648\u0637 \u0628\u0647 \u0631\u062f\u06cc\u0641 \u0641\u0639\u0644\u06cc \u0627\u0633\u062a\u0641\u0627\u062f\u0647 \u0645\u06cc \u0634\u0648\u062f. \u0628\u0631\u062e\u0644\u0627\u0641 \u062a\u0648\u0627\u0628\u0639 \u062c\u0645\u0639\u060c \u062a\u0648\u0627\u0628\u0639 \u067e\u0646\u062c\u0631\u0647 \u0631\u062f\u06cc\u0641 \u0647\u0627 \u0631\u0627 \u062f\u0631 \u06cc\u06a9 \u062e\u0631\u0648\u062c\u06cc \u06af\u0631\u0648\u0647 \u0628\u0646\u062f\u06cc \u0646\u0645\u06cc \u06a9\u0646\u0646\u062f. \u0622\u0646\u0647\u0627 \u06cc\u06a9 \u0646\u062a\u06cc\u062c\u0647 \u0631\u0627 \u0628\u0631\u0627\u06cc \u0647\u0631 \u0631\u062f\u06cc\u0641 \u062f\u0631 \u062d\u0627\u0644\u06cc \u06a9\u0647 \u0632\u0645\u06cc\u0646\u0647 \u0645\u062c\u0645\u0648\u0639\u0647 \u062f\u0627\u062f\u0647 \u0631\u0627 \u062d\u0641\u0638 …<\/p>\n","protected":false},"author":2,"featured_media":90437,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/media2.dev.to\/dynamic\/image\/width=1000,height=500,fit=cover,gravity=auto,format=auto\/https%3A%2F%2Fi.imgur.com%2Fc7iQtx4.png","fifu_image_alt":"","footnotes":""},"categories":[339],"tags":[],"class_list":["post-90436","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\/90436","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=90436"}],"version-history":[{"count":0,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/posts\/90436\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media\/90437"}],"wp:attachment":[{"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/media?parent=90436"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/categories?post=90436"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nabfollower.com\/blog\/wp-json\/wp\/v2\/tags?post=90436"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}