{"id":9272,"date":"2022-09-30T13:51:20","date_gmt":"2022-09-30T08:21:20","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=9272"},"modified":"2022-11-13T16:34:38","modified_gmt":"2022-11-13T11:04:38","slug":"window-function-over-clause","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/window-function-over-clause\/","title":{"rendered":"WINDOW FUNCTION (OVER Clause)"},"content":{"rendered":"\n<p>\u0906\u0907\u090f \u0906\u091c window function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 \u091c\u093f\u0938\u092e\u0947 \u0915\u0940 \u0939\u092e Over clause \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\n<p>Database \u092e\u0947 \u0915\u093f\u0938\u0940 \u092d\u0940 Query \u092a\u0930 \u091c\u092c \u0939\u092e\u0947 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Row \u092a\u0930 \u0915\u094b\u0908 Operation \u0915\u0930\u0928\u093e \u0939\u094b \u0914\u0930 \u0909\u0938\u0915\u0947 Result \u0915\u094b \u0915\u093f\u0938\u0940 \u092d\u0940 \u090f\u0915 Row \u092a\u0930 \u092f\u093e \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 row \u092a\u0930 \u0926\u093f\u0916\u093e\u0928\u093e \u0939\u094b \u0924\u092c , \u0914\u0930 \u091c\u092c \u090f\u0915 Row \u0915\u0940 value \u0915\u093f\u0938\u0940 \u0913\u0930 Row \u092a\u0930 \u0932\u093e\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e Over() Clause \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p>Over Clause \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0939\u092e \u091c\u093f\u0938 \u092d\u0940 Function \u0915\u0947 \u0938\u093e\u0925 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0935\u0939 Window Function \u092c\u0928 \u091c\u093e\u0924\u093e \u0939\u0948\u0902, \u0935\u0948\u0938\u0947 aggregate function \u0939\u0940 \u0910\u0938\u0947 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u091c\u093f\u0928\u094d\u0939\u0947 \u0939\u092e \u092c\u093f\u0928\u093e Over \u0915\u0947 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0932\u0947\u0924\u0947 \u0939\u0948\u0902 \u0932\u0947\u0915\u093f\u0928 \u092c\u093f\u0928\u093e Over \u0915\u0947 \u0935\u0939 \u0915\u0947\u0935\u0932 Aggregate Function \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 Over \u0932\u0917\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0935\u0939 Window Aggregate Function \u092c\u0928 \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p>\u0935\u0948\u0938\u0947 \u0924\u094b window function \u092c\u0939\u0941\u0924 \u0938\u0947 \u0939\u0948\u0902 , \u092e\u0947\u0928\u0947 \u0906\u092a\u0915\u094b \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0905\u0932\u0917 \u0905\u0932\u0917 Category \u0938\u0947 5 -5 function \u0932\u093f\u090f \u0939\u0948\u0902 \u0924\u093e\u0915\u093f \u092e\u0947 \u0906\u092a\u0915\u094b Window Function \u0915\u093e Concept \u092c\u0939\u0941\u0924 \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u092e\u091d\u093e \u0938\u0915\u0941 <\/p>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/mysql-aggregate-function-in-hindi\/\">\u092f\u0926\u093f \u0906\u092a\u0915\u094b Aggregate Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0928\u0939\u0940\u0902 \u0939\u0948\u0902 \u0924\u094b \u0906\u092a \u092f\u0902\u0939\u093e \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964<\/a><\/p>\n\n\n\n<p><strong>Table Of Content<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Over Clause\n<ul class=\"wp-block-list\">\n<li>Over Clause Parameter\n<ul class=\"wp-block-list\">\n<li>Partition By Parameter in Over Cluase <\/li>\n\n\n\n<li>Order By Parameter in Over Cluase<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Difference Between Simple Aggregate Function And Window Aggregate Function<\/li>\n\n\n\n<li>Window Function List\n<ul class=\"wp-block-list\">\n<li><strong>1. Window Aggregate Function<\/strong>\n<ul class=\"wp-block-list\">\n<li>COUNT() OVER()<\/li>\n\n\n\n<li>SUM() OVER()<\/li>\n\n\n\n<li>AVG() OVER()<\/li>\n\n\n\n<li>MIN() OVER() <\/li>\n\n\n\n<li>MAX() OVER()<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>2. Window Rank Function or Non Aggregate Function<\/strong>\n<ul class=\"wp-block-list\">\n<li>ROW_NUMBER() OVER() <\/li>\n\n\n\n<li>RANK() OVER()<\/li>\n\n\n\n<li>DENSE_RANK() OVER()<\/li>\n\n\n\n<li>PERCENT_RANK() OVER()<\/li>\n\n\n\n<li>NTILE() OVER()<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>3. Window Analytical Function \/ Non aggregate function <\/strong>\n<ul class=\"wp-block-list\">\n<li>FIRST_VALUE(ColumnName) OVER()<\/li>\n\n\n\n<li>LAST_VALUE(ColumnName) OVER()<\/li>\n\n\n\n<li>NTH_VALUE(ColumnName, Position) OVER()<\/li>\n\n\n\n<li>LAG(ColumnName) OVER()<\/li>\n\n\n\n<li>LEAD(ColumnName) OVER()<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">OVER() Clause<\/h2>\n\n\n\n<p>\u091c\u0948\u0938\u093e \u0915\u0940 \u0939\u092e\u0928\u0947 \u0938\u092e\u091d \u0915\u0940 Over Clause \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u0947 \u0938\u0947 \u0915\u0947\u0935\u0932 aggreage function \u0939\u0940 window aggregate function \u092c\u0928\u0924\u0947 \u0939\u0948\u0902 \u0905\u0928\u094d\u092f \u0915\u094b\u0908 \u092d\u0940 function window function \u0928\u0939\u0940\u0902 \u092c\u0928\u0924\u093e \u0939\u0948\u0902 \u0915\u0941\u091b \u0905\u0932\u0917 \u0938\u0947 \u0939\u0940 function \u0939\u0948\u0902 \u091c\u093f\u0928\u0915\u0947 \u0938\u093e\u0925 \u0939\u092e\u0947 Over() clause \u0932\u0917\u093e\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0924\u092c \u0939\u0940 \u0935\u0939 \u0915\u093e\u0930\u094d\u092f \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 , \u092c\u093f\u0928\u093e Over() \u0915\u0947 \u0935\u0939 Error \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Over Clause Parameter <\/h3>\n\n\n\n<p>Over Clause \u0915\u094b \u0906\u092a \u092c\u093f\u0928\u093e Parameter \u0915\u0947 \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0914\u0930 parameter \u0932\u0917\u093e \u0915\u0930 \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948, \u092e\u0941\u0916\u094d\u092f \u0930\u0942\u092a \u0938\u0947 \u0905\u0927\u093f\u0915 \u0909\u092a\u092f\u094b\u0917 \u0939\u094b\u0928\u0947 \u0935\u093e\u0932\u0947 \u0926\u094b Parameter \u0928\u093f\u092e\u094d\u0928 \u0939\u0948\u0902  \u0964 <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Partition By <\/li>\n\n\n\n<li>Order By  <\/li>\n<\/ol>\n\n\n\n<h3 class=\"wp-block-heading\">Partition By Parameter in Over Cluase <\/h3>\n\n\n\n<p>&lt;WindowFunctionName&gt; OVER (PARTITION BY &lt;ColumnName&gt;)<\/p>\n\n\n\n<p>\u091c\u092c \u0939\u092e\u0947 window function \u0915\u0947 \u0915\u093e\u0930\u094d\u092f \u0915\u094b \u0938\u092d\u0940 Rows \u092a\u0930 \u0928 \u0915\u0930\u0924\u0947 \u0939\u0941\u0935\u0947 Column Value \u0915\u0947 \u090f\u0915 Group \u092a\u0930 \u0915\u0930\u0928\u093e \u0939\u094b , \u092f\u093e\u0928\u093f \u0915\u0940 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Row \u0915\u0947 \u090f\u0915 group \u092a\u0930 \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e partition by &lt;ColumnName&gt; \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964 \u090f\u0915 \u0924\u0930\u0939 \u0938\u0947 \u092f\u0939 group by \u091c\u0948\u0938\u093e \u0939\u0940 \u0939\u0948\u0902, \u091c\u094b \u092d\u0940 \u0939\u092e Operation Perform \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0935\u0939 Group of Rows \u092a\u0930 \u0939\u0940 Applicable \u0939\u094b\u0924\u093e \u0939\u0948 \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 value Reset \u0939\u094b \u091c\u093e\u0924\u0940 \u0939\u0948 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">SELECT *,  \nSUM(qty) OVER(PARTITION BY CUST_NM) as SUM_A , \nSUM(qty) OVER(PARTITION BY ITEM_NM) as SUM_B\nFROM `citemmst` ORDER BY ID<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"294\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-27.png?resize=640%2C294&#038;ssl=1\" alt=\"Window Function Partition By \" class=\"wp-image-9320\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-27.png?w=813&amp;ssl=1 813w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-27.png?resize=300%2C138&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-27.png?resize=768%2C352&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-27.png?resize=150%2C69&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"block-9cac9daa-7890-471c-adb7-b924dc166420\">Order By Parameter in Over Cluase<\/h3>\n\n\n\n<p id=\"block-abf3f5d7-2059-40e1-a995-6a8ac69f1a24\">&lt;WindowFunctionName&gt; OVER ORDER BY &lt;ColumnName&gt; ASC\/DESC)<\/p>\n\n\n\n<p>\u091c\u094b \u092d\u0940 Operation \u0939\u092e Perform \u0915\u0930 \u0930\u0939\u0947 \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 Rows \u0915\u0940 Sequence \u0915\u094d\u092f\u093e \u0930\u0916\u0928\u093e \u0939\u0948\u0902 \u0935\u0939 \u092d\u0940 \u0939\u092e Over() Function \u0915\u0947 parameter \u092e\u0947 \u092c\u0924\u093e \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0924\u093e\u0915\u093f Rows \u0915\u0940 Sequence \u092c\u0926\u0932 \u091c\u093e\u090f , <a href=\"https:\/\/selfimagination.in\/tips\/order-by-clause-in-mysql\/\">Order By Clause \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f  \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 \u0964<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Parameter Type <\/h3>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Partition By \u0914\u0930 Order By \u092f\u0939 \u0926\u094b\u0928\u094b\u0902 \u0939\u0940 Optional Parameter \u0939\u0948\u0902, \u092f\u093e\u0928\u093f \u0915\u0940 \u0907\u0928\u0915\u0947 \u0909\u092a\u092f\u094b\u0917 \u0928\u0939\u0940\u0902 \u092d\u0940 \u0915\u0930\u0947 \u0924\u094b \u0915\u094b\u0908 \u0907\u0936\u0942 \u0928\u0939\u0940\u0902 \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>\u0906\u092a \u0915\u093f\u0938\u0940 \u090f\u0915 \u0915\u093e \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948. <\/li>\n\n\n\n<li>\u0926\u094b\u0928\u094b\u0902 \u0915\u093e \u090f\u0915 \u0938\u093e\u0925 \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 <\/li>\n\n\n\n<li>\u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0938\u092e\u092f Partitiion by \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u092a\u0939\u0932\u0947 \u0915\u0930\u0947 \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 Order By \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947\u0964 <\/li>\n\n\n\n<li>\u092f\u0926\u093f \u0906\u092a\u0915\u0940 requirement \u092e\u0947 \u0915\u094b\u0908 \u091a\u0947\u0902\u091c\u0947\u0938 \u0939\u0948\u0902 \u0924\u094b \u0906\u092a \u092a\u0939\u0932\u0947 Order by \u0915\u093e \u092d\u0940 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n<\/ol>\n\n\n\n<p>\u0906\u0907\u090f \u0905\u092c \u0939\u092e Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">SELECT *, sum(qty) over(ORDER by ID) as SUM_A FROM `citemmst`<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"409\" height=\"373\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-29.png?resize=409%2C373&#038;ssl=1\" alt=\"Over Function Order By Example\" class=\"wp-image-9325\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-29.png?w=409&amp;ssl=1 409w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-29.png?resize=300%2C274&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-29.png?resize=150%2C137&amp;ssl=1 150w\" sizes=\"auto, (max-width: 409px) 100vw, 409px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><\/p>\n\n\n\n<p><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.sl.SQL_Logic\" target=\"_blank\" rel=\"noopener\">Learn MySQL Android App Download \u0915\u0930\u0947 \u0914\u0930 \u0939\u093f\u0928\u094d\u0926\u0940 \u092e\u0947 MySQL \u0938\u0940\u0916\u0947 <\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Difference Between <strong>Simple Aggregate Function<\/strong> And <strong>Window Aggregate Function<\/strong><\/h2>\n\n\n\n<p>Simple Aggregate function \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 rows \u0915\u0947 \u0921\u093e\u091f\u093e \u0915\u094b Sum \u0915\u0930 single Row \u092e\u0947 value Return \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u091c\u092c\u0915\u093f over function \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 rows \u0915\u094b Sum \u0924\u094b\u0902 \u0915\u0930\u0924\u093e \u0939\u0948\u0902 \u092a\u0930\u0902\u0924\u0941 Value \u0915\u094b \u0938\u092d\u0940 row \u092a\u0930 display \u0915\u0930 \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u0964  <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"246\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-25.png?resize=640%2C246&#038;ssl=1\" alt=\"Difference Between Aggregate Function and Windows Aggregate Function\" class=\"wp-image-9314\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-25.png?w=935&amp;ssl=1 935w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-25.png?resize=300%2C116&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-25.png?resize=768%2C296&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-25.png?resize=150%2C58&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/software-project-planning\/\">\u0915\u093f\u0938\u0940 \u092d\u0940 SOFTWARE PROJECT PLANNING \u0915\u0948\u0938\u0947 \u0915\u0940 \u091c\u093e\u0924\u0940 \u0939\u0948\u0902 ?<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">1. <strong>Window Aggregate Function<\/strong><\/h2>\n\n\n\n<p>\u091c\u094b \u092d\u0940 \u0939\u092e\u0928\u0947 Aggregate Function \u092e\u0947 Read \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0909\u0928\u094d\u0939\u0940 Function \u092e\u0947 \u092f\u0926\u093f Over Clause \u0915\u093e \u0914\u0930 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0932\u093f\u092f\u093e \u091c\u093e\u090f \u0924\u092c \u0935\u0939\u0940 \u0938\u093e\u0930\u0947 function Window Aggregate Function \u092c\u0928 \u091c\u093e\u0924\u0947 \u0939\u0948 \u0964 \u0907\u0938\u092e\u0947 \u0939\u092e\u0947 Group By \u0915\u0930\u0928\u0947 \u0915\u0940 \u091c\u0930\u0942\u0930\u0924 \u0928\u0939\u0940\u0902 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902  \u0964 <\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>COUNT() OVER() : \u0917\u093f\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f <\/li>\n\n\n\n<li>SUM() OVER() : Sum \u092f\u093e \u091f\u094b\u091f\u0932 \u0932\u0917\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f <\/li>\n\n\n\n<li>AVG() OVER() : Average \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f <\/li>\n\n\n\n<li>MIN() OVER(): Minimum Value Find \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0964 <\/li>\n\n\n\n<li>MAX() OVER() : Maximum Value Find \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0964 <\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">\nSELECT *,  \nCOUNT(qty) over() as C_COUNT , \nSUM(qty) over() as C_SUM,  \nAVG(qty) over() as C_AVG,\nMIN(qty) over() as C_MIN,  \nMAX(qty) over() as C_MAX \nFROM `citemmst`<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"210\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-26.png?resize=640%2C210&#038;ssl=1\" alt=\"Window Aggregate Function Example\" class=\"wp-image-9318\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-26.png?w=956&amp;ssl=1 956w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-26.png?resize=300%2C98&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-26.png?resize=768%2C251&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-26.png?resize=150%2C49&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/programming-language\/\">Web Development ke liye Programming Language \u0915\u0940 \u0932\u093f\u0902\u0915\u093f\u0902\u0917 \u0938\u092e\u091d\u0947 <\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/95bNZTG-zZk\" data-type=\"URL\" data-id=\"https:\/\/youtu.be\/95bNZTG-zZk\" target=\"_blank\" rel=\"noopener\">Related Video :  MySQL Sum Window Function | Cumulative Sum Example<\/a><\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">2. <strong>Window Rank Function or non Aggregate Function<\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>ROW_NUMBER() OVER() <\/li>\n\n\n\n<li>RANK() OVER()<\/li>\n\n\n\n<li>DENSE_RANK() OVER()<\/li>\n\n\n\n<li>PERCENT_RANK() OVER()<\/li>\n\n\n\n<li>NTILE() OVER()<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">SELECT *, ROW_NUMBER() OVER(ORDER BY RATE) AS A, \nRANK() OVER(ORDER BY RATE) AS B, \nDENSE_RANK() OVER(ORDER BY RATE) AS C, \nPERCENT_RANK() OVER(ORDER BY RATE) AS D, \nNTILE(5) OVER(ORDER BY RATE) AS E \nFROM CITEMMST<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"571\" height=\"308\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-30.png?resize=571%2C308&#038;ssl=1\" alt=\"Window Rank Functions Example\" class=\"wp-image-9327\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-30.png?w=571&amp;ssl=1 571w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-30.png?resize=300%2C162&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-30.png?resize=60%2C31&amp;ssl=1 60w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-30.png?resize=150%2C81&amp;ssl=1 150w\" sizes=\"auto, (max-width: 571px) 100vw, 571px\" \/><\/figure>\n\n\n\n<p><strong>ROW_NUMBER() OVER(ORDER BY RATE) AS A :<\/strong> \u0910\u0938\u093e \u0932\u093f\u0916\u0928\u0947 \u0938\u0947 \u0906\u092a \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0915\u0940 Rate \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 Record Sort \u0939\u0941\u0935\u0947 \u0939\u0948\u0902 \u0914\u0930 \u090f\u0915 Number Provide \u0915\u0930 \u0926\u093f\u090f \u0939\u0948\u0902 1 \u0938\u0947 8 \u0924\u0915 , Row_Number \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u0947 \u0938\u0947 \u091c\u0940\u0924\u0928\u0947 \u092d\u0940 records \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0909\u0928\u0915\u094b Number Allot \u0915\u0930 \u0926\u093f\u090f \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/bQPoQA_QWhw\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Row Number Window Function in Hindi<\/a><\/p>\n\n\n\n<p><strong>RANK() OVER(ORDER BY RATE) AS B : <\/strong>\u0910\u0938\u093e \u0932\u093f\u0916\u0928\u0947 \u0938\u0947 \u0906\u092a \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0915\u0940 \u091c\u094b \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0939\u0948\u0902 \u0909\u0938\u0947 1 number \u0926\u093f\u092f\u093e \u0917\u092f\u093e , \u091c\u093f\u0928\u0915\u0947 Rate Same \u0939\u0948\u0902 \u0909\u0928\u094d\u0939\u0947 \u092d\u0940 \u092e\u093f\u0932\u0924\u0940 \u091c\u0941\u0932\u0924\u0940 \u0939\u0940 Rank \u0926\u0940, \u091c\u092c \u090f\u0915 Rank \u0926\u094b Record \u0915\u094b \u0926\u0940 \u0939\u0948\u0902 \u0924\u092c 2 \u0930\u0948\u0902\u0915 \u0915\u094b \u0939\u091f\u093e \u0926\u0940 \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 3 Rank \u0926\u0940 \u0939\u0948\u0902 , \u0939\u092e\u0928\u0947 \u092f\u0939\u093e rate \u0938\u0947 Example \u0932\u093f\u092f\u093e \u0939\u0948\u0902 \u092f\u0926\u093f \u0906\u092a \u0907\u0938\u0947 Student \u0915\u0940 rank \u0938\u0947 \u0938\u092e\u091d\u0947\u0902\u0917\u0947 \u0924\u094b \u0914\u0930 \u0906\u0938\u093e\u0928\u0940 \u0938\u0947 \u0938\u092e\u091d \u092e\u0947 \u0906 \u091c\u093e\u090f\u0917\u093e \u0964 \u0910\u0938\u093e \u0939\u0940 \u0906\u0917\u0947 3 \u0930\u0948\u0902\u0915 \u092d\u0940 \u0926\u094b record \u0915\u094b \u0926\u0940 \u0939\u0948\u0902 \u0924\u094b 4 \u0930\u0948\u0902\u0915 \u0915\u094b \u0939\u091f\u093e \u0926\u093f\u092f\u093e next 5 \u0930\u0948\u0902\u0915 \u0926\u0940 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><strong>DENSE_RANK() OVER(ORDER BY RATE) AS C :<\/strong> Dense Rank \u092e\u0947 \u090f\u0915 \u0924\u0930\u0939 \u0938\u0947 Rank \u0939\u0940 \u0939\u0948\u0902 \u0907\u0938\u092e\u0947 \u0915\u0947\u0935\u0932 \u091c\u094b \u0930\u0948\u0902\u0915 \u092e\u0947 \u090f\u0915 \u091c\u0948\u0938\u0947 Record \u0939\u094b\u0928\u0947 \u092a\u0930 \u0939\u092e next number \u0915\u094b \u0939\u091f\u093e \u0930\u0939\u0947 \u0925\u0947 \u0907\u0938\u092e\u0947 \u0909\u0938\u0947 \u0939\u091f\u093e\u0924\u0947 \u0928\u0939\u0940\u0902 \u0939\u0948\u0902 , \u091c\u0948\u0938\u0947 \u092a\u0939\u0932\u0947 \u0926\u094b record same \u0939\u0948\u0902 \u0924\u092c \u0939\u092e\u0947 \u0924\u0940\u0938\u0930\u0947 record \u0915\u094b \u0926\u0942\u0938\u0930\u0940 \u0930\u0948\u0902\u0915 \u0926\u0940 \u0939\u0948\u0902 \u0935\u0948\u0938\u0947 \u0939\u0940 \u0906\u0917\u0947 \u0915\u0947 \u0926\u094b record \u092d\u0940 same \u0939\u0948\u0902 \u0909\u0928\u0915\u094b \u092d\u0940 \u090f\u0915 \u091c\u0948\u0938\u0947 rank \u0926\u0947\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u0917\u0947 \u0915\u0940 \u0930\u0948\u0902\u0915 \u0915\u094b 3 \u0926\u093f\u092f\u093e \u0939\u0948\u0902 , \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u091f\u094b\u091f\u0932 8 Records \u092e\u0947 6 Rank \u0926\u0940 \u0917\u0908 \u0939\u0948\u0902 \u091c\u094b \u0915\u0940 Rank Function \u092e\u0947 8 \u0926\u0940 \u0917\u0908 \u0925\u0940 \u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/1HFXZLx_Pec\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Rank &amp; Dense Rank in Detail in Hindi<\/a><\/p>\n\n\n\n<p><strong>PERCENT_RANK() OVER(ORDER BY RATE) AS D :<\/strong> \u0907\u0938\u0915\u093e Calculation \u0905\u0932\u0917 \u0924\u0930\u0939 \u0938\u0947 \u0939\u0940 \u0939\u094b\u0924 \u0939\u0948\u0902 , \u0906\u0907\u090f \u092e\u0947 \u0906\u092a\u0915\u094b \u0938\u092e\u091d\u0924\u093e \u0939\u0941 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0938\u092c\u0938\u0947 \u091b\u094b\u091f\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b 0 \u092e\u093e\u0928\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>\u0938\u092c\u0938\u0947 \u092c\u095c\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0915\u094b 1 \u092e\u093e\u0928\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 <\/li>\n\n\n\n<li>\u091f\u094b\u091f\u0932 \u091c\u093f\u0924\u0928\u0940 Rows \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0909\u0938\u0915\u094b \u0939\u092e\u0947 0 \u0938\u0947 \u0932\u0947\u0915\u0930 1 \u0924\u0915 \u092e\u0947 \u092c\u093e\u091f\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<p>Diff = 1 \/ (No. Of Rows -1) <\/p>\n\n\n\n<p>No. Of Rows = 8 \u0924\u092c 1 \/ (8-1) \u0939\u094b\u0917\u093e 0.14285 \u0915\u0947 \u0932\u0917\u092d\u0917 <\/p>\n\n\n\n<p>\u0905\u092c \u0939\u092e \u092a\u0939\u0932\u0940 Row \u0915\u094b Zero \u0914\u0930 \u0909\u0938\u0915\u0947 \u092c\u093e\u0926 \u0915\u0940 \u0939\u0930 Row \u092a\u0930 0.1428571429 \u091c\u094b\u095c\u0924\u0947 \u091c\u093e\u090f\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"451\" height=\"220\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-34.png?resize=451%2C220&#038;ssl=1\" alt=\"Percent_rank Example\" class=\"wp-image-9358\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-34.png?w=451&amp;ssl=1 451w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-34.png?resize=300%2C146&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-34.png?resize=150%2C73&amp;ssl=1 150w\" sizes=\"auto, (max-width: 451px) 100vw, 451px\" \/><\/figure>\n\n\n\n<p>\u0905\u092c \u0939\u092e\u0947 \u0907\u0938 \u0905\u0928\u0941\u0938\u093e\u0930 Ranking \u0926\u0947\u0928\u093e \u0939\u0948\u0902 \u0915\u0947\u0935\u0932 \u091c\u093f\u0928\u0915\u0947 Rate \u090f\u0915 \u091c\u0948\u0938\u0947 \u0939\u0948\u0902 \u0909\u0928\u0915\u0940 \u0930\u0948\u0902\u0915 \u092d\u0940 \u090f\u0915 \u091c\u0948\u0938\u0940 \u0939\u094b \u091c\u093e\u090f\u0917\u0940 <\/p>\n\n\n\n<p><strong>NTILE(5) OVER(ORDER BY RATE) AS E :<\/strong> NTILE Function \u092e\u0947 \u0906\u092a \u091c\u094b \u092d\u0940 Parameter Pass \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0935\u0939 \u0938\u092d\u0940 Record \u0915\u094b \u0909\u0924\u0928\u0947 \u092d\u093e\u0917\u094b\u0902 \u092e\u0947 \u092c\u093e\u091f \u0926\u0947\u0924\u093e \u0939\u0948\u0902 \u091c\u0948\u0938\u093e \u0915\u0940 \u0906\u092a \u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u0909\u0926\u093e\u0939\u0930\u0923 \u092e\u0947 \u0926\u0947\u0916 \u0930\u0939\u0947 \u0939\u094b\u0902\u0917\u0947 \u0915\u0940 \u092a\u0939\u0932\u0947 \u0926\u094b \u0915\u094b 1 \u0926\u0942\u0938\u0930\u0947 \u0926\u094b \u0915\u094b 2 \u0924\u0940\u0938\u0930\u0947 2 \u0915\u094b 3 \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0906\u0916\u0930\u0940 \u0935\u093e\u0932\u0947 \u0915\u094b 5 \u0926\u093f\u092f\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u0939\u092e\u093e\u0930\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0926\u0940 \u0917\u0908 \u0938\u0902\u0916\u094d\u092f\u093e 5 \u0939\u0948\u0902, \u0914\u0930 \u091f\u094b\u091f\u0932 \u0930\u093f\u0915\u093e\u0930\u094d\u0921 8 \u0939\u0948\u0902 \u0905\u092c \u092f\u0926\u093f 8 \u0915\u094b 5 \u0938\u0947 \u092d\u093e\u0917 \u092a\u0930 \u0936\u0947\u0937 3 \u092c\u091a\u0947\u0917\u093e \u0914\u0930 \u090f\u0915 \u092c\u093e\u0930 \u092a\u0942\u0930\u093e \u092d\u093e\u0917 \u091c\u093e\u090f\u0917\u093e , <\/li>\n\n\n\n<li>\u0910\u0938\u0947 \u0915\u0947\u0938 \u092e\u0947 \u091c\u094b Extra 3 \u0935\u0948\u0932\u094d\u092f\u0942 \u0939\u0948\u0902 \u0909\u0928\u094d\u0939\u0947 \u092a\u0939\u0932\u0947 \u0915\u0947 \u0924\u0940\u0928 \u0928\u0902\u092c\u0930 \u092e\u0947 Allot \u0915\u0930 \u0926\u093f\u092f\u093e \u091c\u093e\u090f\u0917\u093e \u0964 <\/li>\n<\/ul>\n\n\n\n<p>\u092f\u0926\u093f \u0939\u092e \u0938\u092e\u091d\u0947 \u0915\u0940 \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 8 \u0938\u0947\u092c \u0939\u0948\u0902 \u0914\u0930 \u0909\u0938\u0947 \u0939\u092e\u0947 5 \u092c\u0949\u0915\u094d\u0938 \u092e\u0947 \u0930\u0916\u0928\u093e \u0939\u0948\u0902 \u0924\u094b \u0915\u0948\u0938\u0947 \u0930\u0916\u0947\u0902\u0917\u0947 \u0964 \u090f\u0915 \u090f\u0915 \u0938\u0947\u092c \u0915\u094b \u090f\u0915 \u090f\u0915 box \u092e\u0947 \u0930\u0916\u0928\u0947 \u092a\u0930 5 \u0938\u0947\u092c \u0924\u094b \u0930\u0916\u093e \u091c\u093e\u090f\u0902\u0917\u0947\u0964 \u0905\u092c \u091c\u094b 3 \u0938\u0947\u092c \u092c\u091a\u0947 \u0939\u0948\u0902 \u0909\u0928\u0915\u094b \u092a\u0939\u0932\u0947 \u0915\u0940 \u0907\u0928 \u092c\u0949\u0915\u094d\u0938 \u092e\u0947 \u090f\u0915 \u090f\u0915 \u0930\u0916 \u0926\u0947\u0902\u0917\u0947 \u0907\u0938 \u0905\u0928\u0941\u0938\u093e\u0930 \u092a\u0939\u0932\u0947 \u0915\u0940 \u0924\u0940\u0928 \u092c\u0949\u0915\u094d\u0938 \u092e\u0947 2 -2 \u0938\u0947\u092c \u0939\u094b\u0902\u0917\u0947 \u0914\u0930 \u0906\u0916\u093f\u0930\u0940 \u0915\u0947 \u0926\u094b box \u092e\u0947 1-1 \u0910\u0938\u093e \u0939\u0940 \u0909\u092a\u0930\u094b\u0915\u094d\u0924 Example \u092e\u0947 \u0939\u094b \u0930\u0939\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">3. <strong>Window Analytical Function \/  non aggregate function <\/strong><\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>FIRST_VALUE(ColumnName) OVER()<\/li>\n\n\n\n<li>LAST_VALUE(ColumnName) OVER()<\/li>\n\n\n\n<li>NTH_VALUE(ColumnName, Position) OVER()<\/li>\n\n\n\n<li>LAG(ColumnName) OVER()<\/li>\n\n\n\n<li>LEAD(ColumnName) OVER()<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">SELECT *, \nFIRST_VALUE(CUST_NM) OVER() AS FIRST,\nLAST_VALUE(ITEM_NM) OVER() AS LAST,\nNTH_VALUE(CUST_NM, 5) OVER() AS 5TH,\nLAG(CUST_NM) OVER()  AS PRV,\nLEAD(ITEM_NM) OVER() AS NEXT\nFROM CITEMMST<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"263\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-31.png?resize=640%2C263&#038;ssl=1\" alt=\"Window Analytical Function Example\" class=\"wp-image-9332\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-31.png?resize=1024%2C421&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-31.png?resize=300%2C123&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-31.png?resize=768%2C316&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-31.png?resize=150%2C62&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-31.png?w=1189&amp;ssl=1 1189w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<p><strong>FIRST_VALUE(CUST_NM) OVER() AS FIRST :<\/strong> \u0926\u093f\u090f \u0917\u090f Column Name \u092a\u0930 \u091c\u094b \u092a\u0939\u0932\u093e Record \u0939\u0948\u0902 \u0935\u0939 \u0938\u092d\u0940 Record \u092a\u0930 \u0926\u093f\u0916\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f First Value Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964 \u092f\u0926\u093f \u0906\u092a \u0915\u093f\u0938\u0940 Group \u092c\u0928\u093e \u0915\u0930 \u0909\u0928\u0915\u0940 First value \u0932\u093e\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a Over Clause \u092e\u0947 Partition By \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e \u0964 <\/p>\n\n\n\n<p><strong>LAST_VALUE(ITEM_NM) OVER() AS LAST :<\/strong> \u0926\u093f\u090f \u0917\u090f Column Name \u092a\u0930 \u091c\u094b \u0906\u0916\u0930\u0940 Record \u0939\u0948\u0902 \u0935\u0939 \u0938\u092d\u0940 Record \u092a\u0930 \u0926\u093f\u0916\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Last_Value Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964 \u092f\u0926\u093f \u0906\u092a \u0915\u093f\u0938\u0940 Group \u092c\u0928\u093e \u0915\u0930 \u0909\u0928\u0915\u0940 Last value \u0932\u093e\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a Over Clause \u092e\u0947 Partition By \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u093e \u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/5AQ6Rv8IeQw\" target=\"_blank\" rel=\"noopener\">Related Video : How to Get FIRST Value &amp; LAST Value in MySQL in Hindi<\/a><\/p>\n\n\n\n<p><strong>NTH_VALUE(CUST_NM, 5) OVER() AS 5TH :<\/strong>  Nth_Value Function \u092e\u0947 \u0939\u092e Position \u0926\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0924\u093e\u0915\u093f \u0939\u092e \u0926\u0940 \u0917\u0908 Value \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 Data \u0926\u0947\u0916 \u0938\u0915\u0947 \u0964 first_value aur last_value \u0915\u0947 \u0909\u092a\u092f\u094b\u0917 \u0938\u0947 \u0906\u092a \u092a\u0939\u0932\u0940 \u0914\u0930 \u0906\u0916\u093f\u0930\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0939\u0940 \u092a\u094d\u0930\u093e\u092a\u094d\u0924 \u0915\u0930 \u092a\u093e \u0930\u0939\u0947 \u0925\u0947 \u0932\u0947\u0915\u093f\u0928 \u0906\u092a <strong>NTH_VALUE<\/strong> \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0926\u093f\u090f \u0917\u090f \u0928\u0902\u092c\u0930 \u0938\u0947 Value \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/gx490SsmikI\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Nth Value Function in Hindi<\/a><\/p>\n\n\n\n<p><strong>LAG(CUST_NM) OVER()  AS PRV :<\/strong> \u091c\u092c \u092d\u0940 \u0906\u092a\u0915\u094b Current Row \u092a\u0930 \u0939\u094b\u0928\u0947 \u092a\u0930 \u0909\u0938\u0938\u0947 \u092a\u0939\u0932\u0940 Row \u0915\u0940 Value Get \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0906 LAG Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p><strong>LEAD(ITEM_NM) OVER() AS NEXT :<\/strong> \u091c\u092c \u092d\u0940 \u0906\u092a Current Row \u092a\u0930 \u0909\u0938\u0938\u0947 \u0928\u0940\u091a\u0947 \u0935\u093e\u0932\u0940 Value \u0915\u094b Get \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a\u0915\u094b LEAD Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948 \u0964 <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u0938\u0940\u0916\u0947 VIDEO \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947<\/h2>\n\n\n\n<ol class=\"wp-block-list\">\n<li>\u0938\u0930\u0932 \u092d\u093e\u0937\u093e \u092e\u0947 Programming \u0938\u0940\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f&nbsp;<a href=\"https:\/\/www.youtube.com\/channel\/UCHLuWJ4xcq70qvWgog4YSrg\" target=\"_blank\" rel=\"noreferrer noopener\">Imagination Code Channel<\/a>&nbsp;\u0915\u094b Subscribe \u0915\u0930\u0947\u0964<\/li>\n\n\n\n<li><a href=\"https:\/\/t.me\/tutorialforlearnmysql\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Telegram Channel<\/a>&nbsp;\u0938\u0947 \u091c\u0941\u0921\u093c\u0947 \u0914\u0930 \u092a\u093e\u090f Article &amp; Video \u092a\u094d\u0930\u0924\u093f\u0926\u0940\u0928<\/li>\n\n\n\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=dwKr33RG3UA&amp;list=PLhJ6tQK0qIcOLAiCWg00L79euGSNVoVno\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Beginner &amp; Advance Playlist in Hindi<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/youtu.be\/dwKr33RG3UA\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Overview in One Video<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/youtu.be\/KbcQOTr10Mk\" target=\"_blank\" rel=\"noreferrer noopener\">MySQL Group By Clause<\/a><\/li>\n<\/ol>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>&nbsp;<\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>\u0906\u0936\u093e \u0939\u0948\u0902 \u092e\u0941\u091d\u0947 \u0915\u0940 \u0906\u092a\u0915\u094b Over Clause \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Window Function \u0938\u092e\u091d \u092e\u0947 \u0906 \u0917\u090f \u0939\u094b\u0902\u0917\u0947, \u092b\u093f\u0930 \u092d\u0940 \u092f\u0926\u093f \u0906\u092a\u0915\u094b \u0915\u094b\u0908 \u092d\u0940 doubt \u0939\u094b \u0924\u094b \u0906\u092a \u092e\u0941\u091d\u0947 Comment \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 <\/p>\n\n\n\n<p>\u0905\u092a\u0928\u093e \u0915\u0940\u092e\u0924\u0940 \u0938\u092e\u092f \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0927\u0928\u094d\u092f\u0935\u093e\u0926 \u0964 <\/p>\n\n\n\n<p> <\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0906\u0907\u090f \u0906\u091c window function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 \u091c\u093f\u0938\u092e\u0947 \u0915\u0940 \u0939\u092e Over clause \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0947\u0902\u0917\u0947 \u0964 Database \u092e\u0947 \u0915\u093f\u0938\u0940 \u092d\u0940 Query \u092a\u0930 \u091c\u092c \u0939\u092e\u0947 \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Row \u092a\u0930 \u0915\u094b\u0908 Operation \u0915\u0930\u0928\u093e \u0939\u094b \u0914\u0930 \u0909\u0938\u0915\u0947 Result \u0915\u094b \u0915\u093f\u0938\u0940 \u092d\u0940 \u090f\u0915 Row \u092a\u0930 \u092f\u093e \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 row \u092a\u0930 \u0926\u093f\u0916\u093e\u0928\u093e \u0939\u094b \u0924\u092c , \u0914\u0930 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9402,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-9272","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/mysql-window-function.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9272","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=9272"}],"version-history":[{"count":135,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9272\/revisions"}],"predecessor-version":[{"id":9477,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9272\/revisions\/9477"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/9402"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=9272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=9272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=9272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}