{"id":2087,"date":"2021-08-02T19:55:29","date_gmt":"2021-08-02T14:25:29","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=2087"},"modified":"2021-11-20T18:09:42","modified_gmt":"2021-11-20T12:39:42","slug":"loop-in-select-query","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/loop-in-select-query\/","title":{"rendered":"Loop in Select Query without Procedure"},"content":{"rendered":"\n<p class=\"wp-block-zozuk-wphindi\"><strong>Loop in Select Query :<\/strong> \u0915\u092d\u0940 \u0915\u092d\u0940 \u0939\u092e\u0947\u0902 SQL \u092e\u0947\u0902 \u090f\u0915 \u0939\u0940 \u0930\u093f\u0915\u0949\u0930\u094d\u0921 \u0915\u0947 Data \u0915\u094b Repeat \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0914\u0930 \u0909\u0938\u092e\u0947 \u092c\u093e\u0915\u093f Information \u0924\u094b same \u0939\u0940 \u0930\u0939\u0924\u0940 \u0939\u0948\u0902 \u092a\u0930\u0928\u094d\u0924\u0941 \u0939\u092e\u0947\u0902 \u0915\u094b\u0908 \u090f\u0915 \u092f\u093e \u0926\u094b Columns \u0915\u0940 Value \u0915\u094b \u092a\u094d\u0930\u0924\u094d\u092f\u0947\u0915 Row \u092a\u0930 \u092c\u0926\u0932\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0907\u0938\u0940 \u091f\u094d\u0930\u093f\u0915 \u092f\u093e Logic \u0915\u094b Loop in Select Query \u0915\u0939\u0924\u0947 \u0939\u0948 \u0964 <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0926\u093f \u0906\u092a\u0915\u0947 \u092a\u093e\u0938 \u092d\u0940 \u0907\u0938 \u0924\u0930\u0939 \u0915\u0940 \u0915\u094b\u0908 Problem \u0939\u0948\u0902 \u0924\u094b \u0906\u092a \u0907\u0938 \u0906\u0938\u093e\u0928 Trick \u0938\u0947 Solution \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0926\u0947\u0916\u093f\u092f\u0947 SELECT SQL \u092e\u0947\u0902 \u0915\u093f\u0938\u0940 \u092d\u0940 \u0924\u0930\u0939 \u0915\u0947 Loop \u0928\u0939\u0940\u0902 \u091a\u0932\u0924\u0947 \u0939\u0948\u0902 \u0935\u0939\u093e \u092a\u0930 \u0939\u092e\u0947\u0902 \u091c\u094b \u092d\u0940 Logic \u0932\u0917\u093e\u0928\u0947 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0935\u0939 \u0915\u0947\u0935\u0932 Table \u0915\u0947 \u0906\u0927\u093e\u0930 \u092a\u0930 \u0939\u0940 \u0932\u0917\u093e\u0928\u0947 \u0939\u094b\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/selfimagination.in\/tips\/learn-c-basic-n-advance\/\">Learn C \u2013 \u0939\u093f\u0902\u0926\u0940 \u092e\u0947\u0902<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-aggregate-function-in-hindi\/\">MySQL Aggregate Function in Hindi<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-sys-exec-example-with-trigger\/\">MySQL SYS_EXEC Example With Trigger<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">GET &amp; POST Method | Difference Between GET &amp; POST<\/a><\/li><li><a href=\"https:\/\/selfimagination.in\/tips\/php-validation-filter-var-preg_match\/\">PHP Validation | filter_var | preg_match<\/a><\/li><\/ul>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Example : Repeat Row Using Loop Logic<\/h2>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/_PMULsqU_-Y\" target=\"_blank\" rel=\"noopener\">\u092f\u0926\u093f \u0906\u092a \u0907\u0938 Logic \u0915\u094b \u0935\u0940\u0921\u093f\u092f\u094b \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 \u0938\u092e\u091d\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0907\u0938 \u0935\u0940\u0921\u093f\u092f\u094b \u0938\u0947 \u0938\u092e\u091d \u0938\u0915\u0924\u0947 \u0939\u0948\u0902<\/a><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0939\u092e \u092f\u0939 \u092e\u093e\u0928\u0924\u0947 \u0939\u0948\u0902 \u0915\u0940 \u0939\u092e\u093e\u0930\u0947 \u092a\u093e\u0938 \u090f\u0915 \u091f\u0947\u092c\u0932 \u091c\u093f\u0938\u092e\u0947 Employee \u0915\u093e ID ,Name , No of Installment , Inst amount Column \u0939\u0948\u0902, \u0905\u092c \u0906\u092a\u0915\u094b \u090f\u0915 SQL \u0932\u093f\u0916 \u0915\u0930 \u091c\u093f\u0924\u0928\u0940 Installment \u0939\u094b \u0909\u0924\u0928\u0940 Row Generate \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE TABLE IF NOT EXISTS `mst_emp` (\n  `emp_id` int(9) NOT NULL AUTO_INCREMENT,\n  `emp_nm` varchar(40) NOT NULL,\n  `inst_amt` decimal(9,0) NOT NULL DEFAULT 0,\n  `no_of_inst` int(9) NOT NULL DEFAULT 0,\n  PRIMARY KEY (`emp_id`)\n);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0907\u0938 SQL \u0938\u0947 \u0939\u092e\u0947\u0902 Testing \u0915\u0947 \u0932\u093f\u090f Data Insert \u0915\u093f\u092f\u093e \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">INSERT INTO `mst_emp` (`emp_id`, `emp_nm`, `inst_amt`, `no_of_inst`) VALUES\n(1, 'Sandip', '1000', 5),\n(2, 'Manish ', '2000', 3);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939 Loop Logic \u0915\u0947 \u0932\u093f\u090f \u0939\u092e \u090f\u0915 Table \u092c\u0928\u093e \u0930\u0939\u0947 \u0939\u0948\u0902, \u092f\u0926\u093f \u0906\u092a \u091a\u093e\u0939\u0947 \u0924\u094b \u0907\u0938\u0947 \u090f\u0915 Dummy Table \u0938\u0947 \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902  <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">CREATE TABLE IF NOT EXISTS `mst_srno` (\n  `i` int(9) NOT NULL AUTO_INCREMENT,\n  PRIMARY KEY (`i`)\n) ;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0926\u0947\u0916\u093f\u092f\u0947 \u0907\u0938 \u0935\u093e\u0932\u0947 Example \u092e\u0947\u0902 Maximum Installment 10 \u0939\u094b \u0938\u0915\u0924\u0940 \u0939\u0948\u0902 \u0910\u0938\u093e \u092e\u093e\u0928 \u0915\u0930 \u092e\u0947\u0928\u0947 \u0907\u0938\u092e\u0947\u0902 10 Records Insert \u0915\u093f\u092f\u0947 \u0939\u0948\u0902, \u0906\u092a\u0915\u094b \u091c\u094b \u092d\u0940 Logic \u0932\u0917\u093e\u0928\u093e \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 \u091c\u093f\u0924\u0928\u0947 Max Record \u091a\u093e\u0939\u093f\u090f \u0909\u0924\u0928\u0940 Row \u0907\u0938 table \u092e\u0947\u0902 \u0939\u094b\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">INSERT INTO `mst_srno` (`i`) VALUES\n(1), (2), (3), (4), (5),\n(6), (7), (8), (9), (10);<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0947\u0902 Mst_Emp \u091f\u0947\u092c\u0932 \u0915\u094b Mst_srno \u0938\u0947 Join \u0915\u0940 \u0939\u0948\u0902 , \u0914\u0930 \u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0947\u0902 \u0915\u094b\u0908 \u092d\u0940 Primary \u0914\u0930 Foreign Key \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0928\u0939\u0940\u0902 \u0915\u093f\u092f\u093e, \u091c\u094b \u092f\u0939\u093e\u0901 \u092a\u0930 Jo joining \u0939\u094b \u0930\u0939\u0940 \u0939\u0948\u0902 \u0909\u0938\u0915\u093e \u0906\u0927\u093e\u0930 No_of_inst \u0935\u093e\u0932\u093e column \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT a.emp_id, a.emp_nm, b.i as inst_no, a.inst_amt \nFROM mst_emp a, mst_srno b \nWHERE b.i &lt;= a.no_of_inst ;\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">Query Execute \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u0939\u092e\u0947\u0902 \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 Output \u092e\u093f\u0932\u0947\u0917\u093e <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"282\" height=\"169\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/08\/SQL-With-Loop.jpg?resize=282%2C169&#038;ssl=1\" alt=\"SQL Loop Logic Without Cursor &amp; While\" class=\"wp-image-2097\"\/><\/figure>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939\u0940 Same output \u0906\u092a \u090f\u0915 Dummy Table \u0938\u0947 \u092d\u0940 \u092c\u0928\u093e \u0938\u0915\u0924\u0947 \u0925\u0947 \u0909\u0938\u0915\u0940 SQL \u0907\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT a.emp_id, a.emp_nm, b.i as inst_no, a.inst_amt \nFROM mst_emp a, \n(\n    select 1 as i union all\n    select 2 as i union ALL\n    select 3 as i union ALL\n    select 4 as i union ALL\n    select 5 as i union ALL\n    select 6 as i union ALL\n    select 7 as i union ALL\n    select 8 as i union ALL\n    select 9 as i union ALL\n    select 10 as i \n)\nb \nWHERE b.i &lt;= a.no_of_inst;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0906\u0936\u093e \u0939\u0948\u0902 \u0906\u092a\u0915\u094b \u0938\u092e\u091d \u092e\u0947\u0902 \u0906 \u0917\u092f\u093e \u0939\u094b\u0917\u093e \u0915\u0940 \u0915\u093f\u0938 \u0924\u0930\u0939 \u0938\u0947 \u0939\u092e SQL \u092e\u0947\u0902 \u0939\u0940 Loop Logic \u0932\u0917\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u092f\u0939\u093e\u0901 \u092a\u0930 b.i&lt;=a.no_of_inst \u0932\u0917\u093e\u0928\u093e \u092c\u0939\u0941\u0924 \u091c\u0930\u0941\u0930\u0940 \u0939\u0948\u0902 \u0928\u0939\u0940\u0902 \u0924\u094b \u0907\u0938\u0915\u093e \u092a\u094d\u0930\u0949\u092a\u0930 \u0930\u093f\u092a\u094d\u0932\u093e\u0908 \u0928\u0939\u0940\u0902 \u0906\u090f\u0917\u093e <\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u0907\u0938 \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u0938\u0947 \u0907\u0928 Question \u0915\u0947 \u092d\u0940 Answer Cover \u0915\u093f\u092f\u0947 \u0917\u090f \u0939\u0948\u0902<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>How can I loop through all rows of a table?<\/strong><\/li><li><strong>How do I loop a MySQL query?<\/strong><\/li><li><strong>Can we use loop in SQL query?<\/strong><\/li><li><strong>Loop in mysql query<\/strong><\/li><li><strong>Loop in mysql select query<\/strong><\/li><li><strong>Loop in mysql select query without procedure<\/strong><\/li><li><strong>Mysql loop through rows<\/strong><\/li><li><strong>Mysql loop example<br><\/strong><\/li><\/ul>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0915\u093f\u0938\u0940 \u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0940 \u0915\u094b\u0908 Query \u0939\u094b \u092f\u093e \u0915\u0941\u091b \u092d\u0940 \u0906\u092a\u0915\u094b \u0907\u0938\u0938\u0947 \u0938\u092e\u094d\u092c\u0902\u0927\u093f\u0924 \u0938\u092e\u091d\u0928\u093e \u0939\u094b \u0924\u094b \u0906\u092a Comment \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932 Learn C \u2013 \u0939\u093f\u0902\u0926\u0940 \u092e\u0947\u0902 MySQL Aggregate Function in Hindi MySQL SYS_EXEC Example With Trigger GET &amp; POST Method | Difference Between GET &amp; POST PHP Validation | filter_var | preg_match Example : Repeat Row Using Loop Logic \u092f\u0926\u093f \u0906\u092a \u0907\u0938 Logic \u0915\u094b \u0935\u0940\u0921\u093f\u092f\u094b \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 \u0938\u092e\u091d\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0907\u0938 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2100,"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-2087","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\/2021\/08\/mysql-loop-in-select-query-logic.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2087","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=2087"}],"version-history":[{"count":31,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2087\/revisions"}],"predecessor-version":[{"id":5328,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/2087\/revisions\/5328"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/2100"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=2087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=2087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=2087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}