{"id":9027,"date":"2022-09-19T07:00:00","date_gmt":"2022-09-19T01:30:00","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=9027"},"modified":"2022-09-10T14:43:48","modified_gmt":"2022-09-10T09:13:48","slug":"order-by-clause-in-mysql","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/order-by-clause-in-mysql\/","title":{"rendered":"Order By Clause in Hindi"},"content":{"rendered":"\n<p>SQL \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u091c\u092c \u092d\u0940 \u0939\u092e Table \u0938\u0947 Data fetch \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938\u0947 \u0915\u093f\u0938 Order \u092e\u0947 \u0926\u093f\u0916\u093e\u0928\u093e \u0939\u0948\u0902 \u092f\u093e \u0909\u0938\u0915\u0940 Sorting \u0915\u0948\u0938\u0947 \u0915\u093f\u0938 Column \u092a\u0930 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u092f\u0939 \u0938\u092c Order By \u0915\u0940 \u0939\u0947\u0932\u094d\u092a \u0938\u0947 Possible \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u093e\u0928\u093f \u0915\u0940 \u0939\u092e \u0915\u0939 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0915\u0940 \u0939\u092e\u0928\u0947 \u091c\u094b \u092d\u0940 Select from where group having \u0932\u0917\u093e\u0915\u0930 \u091c\u094b \u092d\u0940 \u092b\u093e\u0907\u0928\u0932 Data \u0932\u093e\u090f \u0939\u0948\u0902 \u0909\u0938\u0915\u0940 Row \u0915\u0940 Sequence \u0915\u094d\u092f\u093e \u0930\u0916\u0928\u093e \u0939\u0948\u0902 \u0935\u0939 \u0938\u092c Order By Clause \u0938\u0947 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<p>TOC : \u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092e\u0947 \u0939\u092e Order By \u0915\u0947 \u0928\u093f\u092e\u094d\u0928 \u0909\u092a\u092f\u094b\u0917 \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u0938\u0940\u0916\u0947\u0902\u0917\u0947 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"#single-column\">Order By on Single Column<\/a> <\/li><li><a href=\"#multiple-column\">Order By on Multiple Columns<\/a><\/li><li><a href=\"#alias-column\">Order By on Alias Columns <\/a><\/li><li><a href=\"http:\/\/aggregate\" target=\"_blank\">Order By on Aggregate Values <\/a><\/li><li><a href=\"#union-all\">Order By on Union \/ Union All<\/a> <\/li><\/ul>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"single-column\">Order By on Single Column <\/h2>\n\n\n\n<p>\u0906\u092a \u0928\u093f\u092e\u094d\u0928 Example \u092e\u0947 \u0926\u0947\u0916 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0939\u092e\u0928\u0947 \u090f\u0915 Table \u0915\u094b without Order by \u0915\u0947 open \u0915\u093f\u092f\u093e \u0924\u092c \u0926\u0947\u0916\u093e \u0917\u092f\u093e \u0915\u0940 Table \u0915\u0940 Sorting \u0909\u0938\u0915\u0940 Primary Key \u0915\u0947 \u0906\u0927\u093e\u0930 \u092a\u0930 \u0939\u0948 \u092f\u093e \u092c\u094b\u0932 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0915\u094b \u091c\u0948\u0938\u0947 \u091c\u0948\u0938\u0947 Data Enter \u0909\u0938 \u0939\u0940 Sequence \u092e\u0947 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947 \u0930\u0939\u093e \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>\u091c\u092c \u0939\u092e\u0928\u0947 Order By cust_nm \u0915\u093f\u092f\u093e \u0924\u092c \u0909\u0938\u0915\u0940 Sorting Customer \u0915\u0947 \u0928\u093e\u092e \u0938\u0947 \u0939\u094b \u0917\u0908 <\/li><li>\u091c\u092c \u0939\u092e\u0928\u0947 Order By qty \u0915\u093f\u092f\u093e \u0924\u092c \u0909\u0938\u0915\u0940 Sorting Qty \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u0939\u094b \u0917\u0908 <\/li><\/ul>\n\n\n\n<p>\u0906\u092a \u091c\u093f\u0938 \u092d\u0940 Column \u0915\u093e \u0928\u093e\u092e Order By \u0915\u0947 \u092c\u093e\u0926 \u0932\u093f\u0916\u0947\u0902\u0917\u0947 \u0909\u0938\u0915\u0947 \u0905\u0928\u0941\u0930\u0942\u092a \u0939\u0940 Sorting \u0939\u094b\u0917\u0940 \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=\"202\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-4.png?resize=640%2C202&#038;ssl=1\" alt=\"\" class=\"wp-image-9032\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-4.png?w=1015&amp;ssl=1 1015w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-4.png?resize=300%2C95&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-4.png?resize=768%2C242&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-4.png?resize=150%2C47&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"multiple-column\">Order By on Multiple Columns<\/h2>\n\n\n\n<p>\u091c\u0948\u0938\u093e \u0915\u0940 \u0906\u092a \u0909\u092a\u0930\u094b\u0915\u094d\u0924 \u0915\u093f\u0938 \u092d\u0940 example \u092e\u0947 \u0926\u0947\u0916 \u0930\u0939\u0947 \u0939\u094b\u0902\u0917\u0947 \u0915\u0940 \u092f\u0926\u093f \u0939\u092e\u0947 \u092a\u0939\u0932\u0947 Column \u092a\u0930 sort \u0915\u093f\u092f\u093e \u0924\u094b \u0905\u0928\u094d\u092f column \u0915\u0947 Sequence \u092c\u0926\u0932 \u091c\u093e\u0924\u0947 \u0939\u0948, \u0909\u0926\u093e\u0939\u0930\u0923 \u0915\u0947 \u0932\u093f\u090f \u092f\u0926\u093f \u0906\u092a \u0928\u093f\u092e\u094d\u0928 \u0909\u0926\u093e\u0939\u0930\u0923 \u092e\u0947 \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0915\u0940 \u0939\u092e\u0928\u0947 order by cust_nm \u0915\u093f\u092f\u093e \u0924\u092c item_nm \u0905\u092a\u0928\u0947 id \u0915\u0947 \u0905\u0928\u0941\u0938\u093e\u0930 \u091c\u094b Sorting \u0925\u0940 \u0909\u0938 \u0905\u0928\u0941\u0938\u093e\u0930 \u0939\u0940 Sort \u0925\u093e, \u091c\u092c \u0939\u092e\u0928\u0947 cust_nm ke \u0938\u093e\u0925 tem_nm \u092d\u0940 \u0932\u093f\u092f\u093e \u0924\u092c item_nm \u0915\u0949\u0932\u092e \u0915\u0940 \u092d\u0940 Sorting \u0939\u0941\u0908 \u0932\u0947\u0915\u093f\u0928 \u0915\u0947\u0935\u0932 cust_nm \u092e\u0947 \u091c\u093f\u0928 Columns \u0915\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u090f\u0915 \u091c\u0948\u0938\u0940 \u0925\u0940 \u0909\u0928\u094d\u092e\u0947 \u0939\u0940 \u0964 <\/p>\n\n\n\n<p>\u092f\u093e\u0928\u093f \u0915\u0940 \u0939\u092e \u0915\u0939 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0915\u0940 <strong>Order By<\/strong>  \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 \u0915\u0949\u0932\u092e \u092a\u0930 \u092d\u0940 working \u0915\u0930\u0924\u093e \u0939\u0948\u0902\u0964  <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"190\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-5.png?resize=640%2C190&#038;ssl=1\" alt=\"\" class=\"wp-image-9038\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-5.png?resize=1024%2C304&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-5.png?resize=300%2C89&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-5.png?resize=768%2C228&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-5.png?resize=150%2C45&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-5.png?w=1054&amp;ssl=1 1054w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"alias-column\">Order By on Alias Columns <\/h2>\n\n\n\n<p>Order By \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0906\u092a Alias \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u092c\u0928\u093e\u090f \u0917\u090f columns \u092e\u0947 \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0906\u0907\u090f \u0938\u092e\u091d\u0924\u0947 \u0939\u0948\u0902 \u0964 \u0907\u0938 \u091f\u0947\u092c\u0932 amt \u0928\u093e\u092e \u0938\u0947 \u0915\u094b\u0908 \u092d\u0940 \u0915\u0949\u0932\u092e \u0928\u0939\u0940\u0902 \u0939\u0948\u0902 \u0939\u092e\u0928\u0947 \u090f\u0915 Virtual Column \u091c\u093f\u0938\u0915\u093e \u0928\u093e\u092e amt \u0930\u0916\u093e \u0939\u0948\u0902 amt \u092e\u0947 \u0939\u092e\u0928\u0947 (Qty * Rate) \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u091c\u093f\u0938\u0938\u0947 \u0915\u0940 \u0907\u0938\u092e\u0947 calculation \u0939\u094b \u0915\u0930 \u090f\u0915 \u0915\u0949\u0932\u092e \u092c\u0928 \u0915\u0930 \u0906\u092f\u093e \u0939\u0948\u0902 \u0914\u0930 \u0909\u0938 \u092a\u0930 \u0939\u092e\u0928\u0947 Sorting \u0915\u0940 \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=\"553\" height=\"293\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-6.png?resize=553%2C293&#038;ssl=1\" alt=\"\" class=\"wp-image-9043\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-6.png?w=553&amp;ssl=1 553w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-6.png?resize=300%2C159&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-6.png?resize=140%2C73&amp;ssl=1 140w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-6.png?resize=60%2C31&amp;ssl=1 60w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-6.png?resize=150%2C79&amp;ssl=1 150w\" sizes=\"auto, (max-width: 553px) 100vw, 553px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"aggregate\">Order By on Aggregate Values <\/h2>\n\n\n\n<p>\u091c\u0940 \u092c\u093f\u0932\u094d\u0915\u0941\u0932 \u0906\u092a \u092f\u0926\u093f \u0915\u093f\u0938\u0940 Aggregate Function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0915\u094b\u0908 value \u0915\u0947 \u0915\u0930 \u0906\u090f \u0939\u0948\u0902 \u0906\u092a \u0909\u0938 \u092a\u0930 \u092d\u0940 Order by \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902\u0964 \u0928\u093f\u092e\u094d\u0928 Example \u092e\u0947 \u0906\u092a \u0926\u0947\u0916\u0947\u0902\u0917\u0947 \u0915\u0940 \u0939\u092e\u0928\u0947 Customer Wise Total Qty Calculate \u0915\u0940 \u0939\u0948\u0902 \u0914\u0930 \u092b\u093f\u0930 \u0909\u0938\u0915\u094b \u0939\u0940 Order By \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Sort \u0915\u0940 \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=\"549\" height=\"254\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-7.png?resize=549%2C254&#038;ssl=1\" alt=\"\" class=\"wp-image-9046\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-7.png?w=549&amp;ssl=1 549w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-7.png?resize=300%2C139&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-7.png?resize=150%2C69&amp;ssl=1 150w\" sizes=\"auto, (max-width: 549px) 100vw, 549px\" \/><\/figure>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/mysql-aggregate-function-in-hindi\/\">Aggregate Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947 \u091c\u093e\u0928\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0902\u0939\u093e \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\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\" id=\"union-all\">Order By on Union \/ Union All <\/h2>\n\n\n\n<p>Order by \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0906\u092a Union \u0914\u0930 union all \u092e\u0947 \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0932\u0947\u0915\u093f\u0928 \u0907\u0938\u092e\u0947 \u0906\u092a\u0915\u094b \u0927\u094d\u092f\u093e\u0928 \u092f\u0939 \u0930\u0916\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0915\u0940 \u0906\u092a \u092f\u0942\u0928\u093f\u092f\u0928 all \u0915\u0947 \u092a\u0939\u0932\u0947 Order By \u0928\u0939\u0940\u0902 \u0932\u0917\u093e \u0938\u0915\u0924\u0947\u0964 \u0906\u0907\u090f \u092e\u0947 \u0906\u092a\u0915\u094b Ek Example \u0938\u0947 \u0938\u092e\u091d\u0924\u093e \u0939\u0941 \u0964 <\/p>\n\n\n\n<p>\u092f\u0926\u093f \u0906\u092a\u0928\u0947 Union \u092f\u093e Union All \u0938\u0947 \u092a\u0939\u0932\u0947 Order By \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u0924\u094b \u0906\u092a\u0915\u094b SQL Execute \u0939\u094b\u0928\u0947 \u092e\u0947 Error \u0906\u090f\u0917\u0940 , \u0907\u0938\u0932\u093f\u090f \u0906\u092a\u0915\u094b Union \u0915\u0947 Case \u092e\u0947 Order By \u0915\u094b \u0939\u092e\u0947\u0936\u093e Last \u092e\u0947 \u0939\u0940 \u0930\u0916\u0928\u093e \u0939\u0948\u0902 , \u0914\u0930 \u092f\u0926\u093f \u0906\u092a \u0905\u0932\u0917 \u0905\u0932\u0917 table \u0938\u0947 data \u0932\u093e \u0930\u0939\u0947 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a\u0915\u094b \u092a\u0939\u0932\u0940 \u0935\u093e\u0932\u0940 \u091f\u0947\u092c\u0932 \u092e\u0947 \u091c\u094b \u0915\u0949\u0932\u092e \u0915\u0947 \u0928\u093e\u092e \u0939\u0948\u0902 \u0909\u0928\u0915\u0947 \u0928\u093e\u092e \u0938\u0947 Sorting \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u093f\u090f \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=\"307\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-9.png?resize=640%2C307&#038;ssl=1\" alt=\"\" class=\"wp-image-9055\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-9.png?w=654&amp;ssl=1 654w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-9.png?resize=300%2C144&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2022\/09\/image-9.png?resize=150%2C72&amp;ssl=1 150w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f Article <\/h2>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/code-editor\/\">Code Editor \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0905\u092a\u0928\u093e \u0938\u092e\u092f \u092c\u091a\u093e\u090f<\/a><br><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">\u0938\u0940\u0916\u0947 C Panel \u0915\u0947 \u0909\u092a\u092f\u094b\u0917\u0940 Options<\/a><br><a href=\"https:\/\/selfimagination.in\/tips\/html-basic\/\">HTML Basic for Beginners<\/a><br><a href=\"https:\/\/selfimagination.in\/tips\/css-tutorial-in-hindi\/\">CSS Basic for Beginners<\/a><br><a href=\"https:\/\/selfimagination.in\/tips\/javascript-tutorial-in-hindi\/\">Javascript For Beginners<\/a><br><a href=\"https:\/\/selfimagination.in\/tips\/mysql-dump-export-import\/\">MySQL Database Backup &amp; Restore \/ MySQL Import Export<\/a><br><a href=\"http:\/\/urllast%20crawled%20https\/\/selfimagination.in\/tips\/mysql-dump-export-import\/%20N\/A%20https:\/\/selfimagination.in\/tips\/php-math-function\/%20N\/A%20https:\/\/selfimagination.in\/tips\/programming-solutions\/%20N\/A%20https:\/\/selfimagination.in\/tips\/quick-code-replacer-tool\/\">Code Replacer \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093e \u0906\u092a Copy Paste \u0935\u093e\u0932\u0947 \u0915\u093e\u0930\u094d\u092f\u094b\u0902 \u092e\u0947 \u0905\u092a\u0928\u093e \u0938\u092e\u092f \u092c\u091a\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/a><\/p>\n\n\n\n<p>\u0906\u092a\u0915\u094b \u092f\u0939 Article \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u0939\u092e\u0947 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u090f \u0964 \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","protected":false},"excerpt":{"rendered":"<p>SQL \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u091c\u092c \u092d\u0940 \u0939\u092e Table \u0938\u0947 Data fetch \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938\u0947 \u0915\u093f\u0938 Order \u092e\u0947 \u0926\u093f\u0916\u093e\u0928\u093e \u0939\u0948\u0902 \u092f\u093e \u0909\u0938\u0915\u0940 Sorting \u0915\u0948\u0938\u0947 \u0915\u093f\u0938 Column \u092a\u0930 \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u092f\u0939 \u0938\u092c Order By \u0915\u0940 \u0939\u0947\u0932\u094d\u092a \u0938\u0947 Possible \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u093e\u0928\u093f \u0915\u0940 \u0939\u092e \u0915\u0939 \u0938\u0915\u0924\u0947 \u0939\u0948 \u0915\u0940 \u0939\u092e\u0928\u0947 \u091c\u094b \u092d\u0940 Select from where group having \u0932\u0917\u093e\u0915\u0930 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9059,"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-9027","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-order-by.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9027","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=9027"}],"version-history":[{"count":41,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9027\/revisions"}],"predecessor-version":[{"id":9075,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9027\/revisions\/9075"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/9059"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=9027"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=9027"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=9027"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}