{"id":577,"date":"2021-02-03T18:36:04","date_gmt":"2021-02-03T13:06:04","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=577"},"modified":"2022-11-13T18:45:17","modified_gmt":"2022-11-13T13:15:17","slug":"select-example","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/select-example\/","title":{"rendered":"SELECT , SELECT *, SELECT Columns, SELECT DISTINCT"},"content":{"rendered":"\n<p><strong>SELECT \u0915\u0947 \u0938\u092d\u0940 ARGUMENT \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0915\u093e\u0930\u0940<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SELECT (\u0921\u093e\u091f\u093e \u0915\u094b \u0926\u0947\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f)<\/li>\n\n\n\n<li>SELECT * (\u0938\u092d\u0940 Columns \u0926\u0947\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f)<\/li>\n\n\n\n<li>SELECT  &lt;Columns List&gt; (Selected Columns \u0915\u0940 \u0932\u093f\u0938\u094d\u091f \u0926\u0947\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f) <\/li>\n\n\n\n<li>SELECT Use of Table Alias (Multiple Table) <\/li>\n\n\n\n<li>SELECT With WHERE (\u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u092e\u093e\u0902\u0921 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 WHERE \u0915\u0947 \u0938\u093e\u0925)<\/li>\n\n\n\n<li>SELECT DISTINCT (\u0921\u0941\u092a\u094d\u0932\u0940\u0915\u0947\u091f \u0921\u093e\u091f\u093e \u0915\u094b Query \u092e\u0947\u0902 \u0938\u0947 \u0939\u091f\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f)<\/li>\n\n\n\n<li>SELECT LIMIT (\u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0932\u093f\u092e\u093f\u091f \u0915\u093e \u0909\u092a\u092f\u094b\u0917 )<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">SELECT <\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u0915\u094b\u0908 \u092d\u0940 Function \u092f\u093e \u0915\u094b\u0908 Calculation \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u091c\u093f\u0938\u092e\u0947 \u0915\u0940 \u0939\u092e \u0915\u093f\u0938\u0940 Table \u0915\u0940 \u091c\u0930\u0942\u0930\u0924 \u0928\u0939\u0940\u0902 \u0939\u094b \u0924\u092c \u0939\u092e \u0915\u0947\u0935\u0932 Select \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Result \u0932\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT now()             \/\/ 2022-07-05 15:34:08\nSELECT (1 + 5) as total  \/\/ 6\nSELECT greatest(1,2)     \/\/ 2<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-string-function\/\">MySQL String Function \u0915\u0947 \u0932\u093f\u090f \u0926\u0947\u0916\u0947 <\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-number-function\/\">MySQL Number Function \u0915\u0947 \u0932\u093f\u090f \u0926\u0947\u0916\u0947 <\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-date-time-function\/\">MySQL Date Time Function \u0915\u0947 \u0932\u093f\u090f \u0926\u0947\u0916\u0947 <\/a><\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">SELECT&nbsp;*  (Display All Columns of Table \/ Tables)<\/h2>\n\n\n\n<p>\u0915\u093f\u0938\u0940 \u092d\u0940 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u091c\u094b \u0939\u092e\u0947\u0902 \u0921\u093e\u091f\u093e \u0907\u0928\u094d\u0938\u0930\u094d\u091f \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0909\u0938\u0947 \u0926\u0947\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e&nbsp;\u0907\u0938 \u0938\u094d\u091f\u0947\u091f\u092e\u0947\u0902\u091f \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948 !<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\"><strong> SELECT * FROM mytable<\/strong><\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p>\u092f\u0939\u093e\u0901 \u092a\u0930 * \u0915\u093e \u092e\u0924\u0932\u092c \u0939\u0948 \u0915\u0940 \u0938\u092d\u0940 \u0915\u0949\u0932\u092e \u0939\u092e \u0926\u0947\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 !<\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/EXQeUybhhJ4\" data-type=\"URL\" data-id=\"https:\/\/youtu.be\/EXQeUybhhJ4\" target=\"_blank\" rel=\"noopener\">Video \u0915\u0947 \u092e\u093e\u0927\u094d\u092f\u092e \u0938\u0947 Select Clause \u0938\u092e\u091d\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947 <\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">SELECT&nbsp;&lt;Columns List&gt;  (Display Selected Columns)<\/h2>\n\n\n\n<p>\u092f\u0926\u093f \u0906\u092a\u0915\u094b \u0938\u093f\u0932\u0947\u0915\u094d\u091f\u0947\u0921 \u0915\u0949\u0932\u092e \u0926\u0947\u0916\u0928\u093e \u0939\u0948 \u0924\u094b \u0939\u092e\u0947\u0902 \u0935\u0939 \u092a\u0930 \u0915\u0949\u0932\u092e \u0915\u0940 \u0932\u093f\u0938\u094d\u091f \u0926\u0947\u0928\u093e \u0939\u094b\u0917\u0940 \u091c\u0948\u0938\u0947<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\"><strong>SELECT column1, column4 FROM mytable<\/strong><\/code><\/pre>\n\n\n\n<p>\u0907\u0938 \u0938\u094d\u091f\u0947\u091f\u092e\u0947\u0902\u091f \u0938\u0947 \u0938\u093f\u0930\u094d\u092b \u0926\u094b \u0939\u0940 \u0915\u0949\u0932\u092e \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0902\u0917\u0947 !<br>SELECT QUERY \u091a\u0932\u093e\u0924\u0947 \u0938\u092e\u092f \u0939\u092e\u0947\u0902 \u0927\u094d\u092f\u093e\u0928 \u0930\u0916\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0915\u0940 \u0909\u0924\u0928\u093e \u0939\u0940 \u0921\u093e\u091f\u093e select \u0915\u0930\u0928\u0947 \u091c\u093f\u0924\u0928\u0947 \u0915\u0940 \u0939\u092e\u0947\u0902 \u091c\u0930\u0941\u0930\u0924 \u0939\u094b, \u0915\u094d\u092f\u0941\u0915\u0940 \u091c\u092c \u0939\u092e\u0947\u0902 Complex&nbsp; Query \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0909\u0938 \u0938\u092e\u092f \u0921\u093e\u091f\u093e \u091c\u094d\u092f\u093e\u0926\u093e \u0939\u094b\u0928\u0947 \u0915\u0947 \u0915\u093e\u0930\u0923 \u0938\u094d\u092a\u0940\u0921 \u0907\u0936\u0942 \u0906\u0928\u0947 \u0932\u0917\u0924\u0947 \u0939\u0948\u0902 !<\/p>\n\n\n\n<p>\u090f\u0915 \u0924\u0930\u0939 \u0938\u0947 \u092f\u0939 COLUMN \u0932\u0947\u0935\u0932 \u092b\u093c\u093f\u0932\u094d\u091f\u0930 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 !<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">SELECT&nbsp;&lt;Columns List&gt;  (Display Columns from Multiple Tables)<\/h2>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0906\u092a\u0915\u094b \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 Table \u092e\u0947 \u0938\u0947 Selected \u0915\u0949\u0932\u092e \u0939\u0940 Display \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0906\u092a\u0915\u094b \u091f\u0947\u092c\u0932 \u0915\u0947 Alias \u0926\u0947 \u0915\u0930 \u0906\u092a . dot \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 column name \u0926\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\"><strong>SELECT a.column1, a.column4 <\/strong>, b.<strong>column1<\/strong>\n<strong>FROM mytable<\/strong> a, mytable2 b  \nWHERE &lt;Table Joining Condition&gt;<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">Dispaly All Columns of Given Table<\/h2>\n\n\n\n<p>\u091c\u092c \u0939\u092e \u090f\u0915 \u0938\u0947 \u0905\u0927\u093f\u0915 \u091f\u0947\u092c\u0932 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0930\u0939\u0947 \u0939\u094b \u0914\u0930 \u0939\u092e\u0947 \u0915\u093f\u0938\u0940 \u090f\u0915 \u091f\u0947\u092c\u0932 \u0915\u0947 \u0938\u092d\u0940 Columns display \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u092c \u0939\u092e Table Name \u092f\u093e table Alias \u0915\u0947 \u092c\u093e\u0926 dot . \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 * \u0932\u0917\u093e \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\"><strong>SELECT a.column1, <\/strong>b.*\n<strong>FROM mytable<\/strong> a, mytable2 b  \nWHERE &lt;Table Joining Condition&gt;<\/code><\/pre>\n\n\n\n<p><\/p>\n\n\n\n<p><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">WHERE&nbsp; (\u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0915\u092e\u093e\u0902\u0921 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 WHERE \u0915\u0947 \u0938\u093e\u0925)<\/h2>\n\n\n\n<p>WHERE \u0938\u094d\u091f\u0947\u091f\u092e\u0947\u0902\u091f \u0939\u092e\u0947\u0936\u093e FROM &lt;TABLE NAME &gt; \u0915\u0947 \u092c\u093e\u0926 \u0909\u092a\u092f\u094b\u0917 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 \u0907\u0938\u0915\u0947 \u0909\u092a\u092f\u094b\u0917 ROW \u0932\u0947\u0935\u0932 \u092b\u093c\u093f\u0932\u094d\u091f\u0930 \u092e\u0947\u0902 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 , \u092f\u093e\u0928\u093f \u0915\u0940 \u091c\u092c \u0939\u092e\u0947\u0902 \u090f\u0915 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0938\u0947 \u0938\u093f\u0932\u0947\u0915\u094d\u091f\u0947\u0921 ROWS \u0939\u0940 \u0926\u0947\u0916\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e \u0907\u0938 \u0915\u092e\u093e\u0902\u0921 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 !<\/p>\n\n\n\n<p>WHERE&nbsp; &lt;COLUMN NAME &gt;&nbsp; &nbsp; OPERATOR&nbsp; &lt;VALUE&gt;<\/p>\n\n\n\n<p>\u0911\u092a\u0930\u0947\u091f\u0930 \u0932\u093f\u0938\u094d\u091f<br>1 . =<br>2 . &lt;=<br>3. &gt;=<br>4. !=<br>5. LIKE&nbsp; &nbsp; (&nbsp; %, \u0914\u0930 _ \u0915\u0947 \u0909\u092a\u092f\u094b\u0917 \u0915\u0947 \u0938\u093e\u0925)<\/p>\n\n\n\n<p>\u0914\u0930 \u0938\u093e\u0925 \u092e\u0947\u0902 AND , OR, NOT&nbsp; &nbsp; \u0911\u092a\u0930\u0947\u091f\u0930 \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u092d\u0940 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u090f\u0915 \u0938\u0947 \u091c\u094d\u092f\u093e\u0926\u093e \u0915\u0902\u0921\u0940\u0936\u0928 \u0915\u094b \u092e\u0930\u094d\u091c \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f !<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\"><strong>SELECT * FROM mytable<\/strong> where column1 = 500;\n<strong>SELECT * FROM mytable<\/strong> where column2 &lt;= 400;\n<strong>SELECT * FROM mytable<\/strong> where column3 &gt; 300;\n<strong>SELECT * FROM mytable<\/strong> where column1 != 0;\n<strong>SELECT * FROM mytable<\/strong> where column1 LIKE 'S%';\n<\/code><\/pre>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/mnMF-0DrVfw\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Where Clause | Filter Table Rows | Join, Operators, Like, Between, In, Not<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/where-clause-in-mysql\/\">Related Article : How to Use Where Clause in MySQL<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">SELECT DISTINCT (\u0921\u0941\u092a\u094d\u0932\u0940\u0915\u0947\u091f \u0921\u093e\u091f\u093e \u0915\u094b Query \u092e\u0947\u0902 \u0938\u0947 \u0939\u091f\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f)&nbsp;<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT DISTINCT\u00a0column1\u00a0\nFROM\u00a0mytable<\/code><\/pre>\n\n\n\n<p>\u092f\u0926\u093f \u0907\u0938 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0915\u0941\u0932 10 \u0930\u093f\u0915\u0949\u0930\u094d\u0921 \u0939\u0948\u0902 \u0914\u0930 \u0915\u0949\u0932\u092e1 \u092e\u0947\u0902 4&nbsp; \u0930\u093f\u0915\u0949\u0930\u094d\u0921 \u092e\u0947\u0902&nbsp;\u090f\u0915 \u091c\u0948\u0938\u0947 \u0935\u0948\u0932\u094d\u092f\u0942 \u0939\u0948\u0902&nbsp; \u091c\u092c \u0939\u092e \u0915\u0949\u0932\u092e1&nbsp; \u0915\u0947 \u0938\u093e\u0925 DISTINCT \u0932\u0917\u093e\u090f\u0902\u0917\u0947 \u0924\u092c \u0921\u0941\u092a\u094d\u0932\u0940\u0915\u0947\u091f \u0930\u093f\u0915\u0949\u0930\u094d\u0921 \u0926\u093f\u0916\u093e\u0908 \u0928\u0939\u0940\u0902 \u0926\u0947\u0902\u0917\u0947, \u091c\u094b 4 \u0930\u093f\u0915\u0949\u0930\u094d\u0921 \u090f\u0915 \u091c\u0948\u0938\u0940 \u0935\u0948\u0932\u094d\u092f\u0942 \u0935\u093e\u0932\u0947 \u0939\u0948\u0902 \u0909\u0928\u092e\u0947 \u0938\u0947 \u090f\u0915 \u0939\u0940 \u0930\u093f\u0915\u0949\u0930\u094d\u0921 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e !<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code class=\"\">SELECT column1 \nFROM mytable \nGROUP BY column1<\/code><\/pre>\n\n\n\n<p><br>\u0907\u0938 \u0915\u092e\u093e\u0902\u0921 \u0938\u0947 \u092d\u0940 \u0935\u0939\u0940 \u0930\u093f\u091c\u0932\u094d\u091f \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u093e \u091c\u094b \u092a\u0939\u0932\u0947 \u0935\u093e\u0932\u0940 \u0915\u092e\u093e\u0902\u0921 \u0938\u0947 \u0939\u094b\u0917\u093e\u00a0<\/p>\n\n\n\n<hr class=\"wp-block-separator has-css-opacity is-style-wide\"\/>\n\n\n\n<h2 class=\"wp-block-heading\">SELECT&nbsp;LIMIT (\u0938\u0947\u0932\u0947\u0915\u094d\u091f \u0932\u093f\u092e\u093f\u091f \u0915\u093e \u0909\u092a\u092f\u094b\u0917&nbsp;)&nbsp;<\/h2>\n\n\n\n<p>SELECT \u0915\u0947 \u0938\u093e\u0925 LIMIT&nbsp; \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0948\u0938\u0947&nbsp;\u0915\u0930\u0924\u0947 \u0939\u0948\u0964&nbsp;<br>LIMIT &#8211; \u091c\u092c \u0915\u093f\u0938\u0940 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u0938\u0947 \u0939\u092e\u0947\u0902 \u0938\u094d\u091f\u093e\u0930\u094d\u091f\u093f\u0902\u0917 \u092f\u093e \u0915\u093f\u0938\u0940 \u0932\u094b\u0915\u0947\u0936\u0928 \u0938\u0947 \u091a\u0941\u0928\u093f\u0902\u0926\u093e \u0930\u093f\u0915\u0949\u0930\u094d\u0921 \u0939\u0940 \u0936\u094b \u0915\u0930\u0928\u093e \u0939\u094b \u0924\u094b \u0939\u092e \u0935\u0947\u092f\u0930 \u0915\u0940 \u0938\u094d\u0925\u093e\u0928 \u092a\u0930 LIMIT \u0915\u0938 \u0909\u092a\u092f\u094b\u0917 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"sql\" class=\"language-sql\">SELECT * FROM mytable\nLIMIT 0,2<\/code><\/pre>\n\n\n\n<p>LIMIT &lt;Starting Index, No. of Records&gt;<\/p>\n\n\n\n<p>Starting Index : \u091c\u094b \u092d\u0940 \u0921\u093e\u091f\u093e \u0939\u092e\u093e\u0930\u0940 \u091f\u0947\u092c\u0932 \u0939\u0948 \u0909\u0938\u0947 \u0915\u093f\u0938 \u0907\u0902\u0921\u0947\u0915\u094d\u0938 \u0938\u0947 \u0936\u094b \u0915\u0930\u0928\u093e \u0939\u0948 , \u092f\u0926\u093f \u092b\u0930\u094d\u0938\u094d\u091f \u0938\u0947 \u0939\u0940 \u0936\u094b \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u0924\u0947&nbsp; \u0939\u0948 \u0924\u094b&nbsp; \u092f\u0939\u093e\u0901 \u092a\u0930 0 \u0926\u0947\u0924\u0947 \u0939\u0948\u0902 \u0914\u0930 \u092f\u0926\u093f \u092f\u0939\u093e\u0901 \u092a\u0930 \u0939\u092e\u0947\u0902 1 \u0926\u093f\u092f\u093e \u0924\u094b \u092b\u0930\u094d\u0938\u094d\u091f \u0915\u093e \u090f\u0915&nbsp; \u0930\u093f\u0915\u0949\u0930\u094d\u0921&nbsp; \u091b\u0942\u091f\u091c\u093e\u090f\u0917\u093e \u0914\u0930 \u0906\u0917\u0947 \u0915\u0947 \u0930\u093f\u0915\u0949\u0930\u094d\u0921 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0928\u0947 \u0932\u0917\u0947\u0902\u0917\u0947\u0964<\/p>\n\n\n\n<p><strong>No. of Records :<\/strong> \u0907\u0938\u0915\u0947 \u0926\u094d\u0935\u093e\u0930\u093e \u0939\u092e\u0947\u0902 \u0915\u093f\u0924\u0928\u0940 ROW&nbsp; \u0936\u094b \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0935\u0939 \u0907\u0938 \u092a\u0948\u0930\u093e\u092e\u0940\u091f\u0930 \u0938\u0947 \u0938\u0947\u091f \u0915\u0930\u0924\u0947 \u0939\u0948\u0902, \u091c\u0948\u0938\u0947 \u0939\u092e\u0947\u0902 2 Rows show \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u0924\u094b \u092f\u0939\u093e\u0901 \u092a\u0930 2 \u0932\u093f\u0916\u0947\u0902\u0917\u0947, \u0914\u0930 \u091c\u094d\u092f\u093e\u0926\u093e Rows&nbsp;\u0932\u093e\u0928\u093e \u0939\u094b \u0924\u094b \u091c\u093f\u0924\u0928\u0940 Rows \u0932\u093e\u0928\u093e \u0939\u0948\u0902 \u0909\u0924\u0928\u093e \u0932\u093f\u0916\u0947\u0902\u0917\u0947\u0964<\/p>\n\n\n\n<p><strong>ORDER BY : <\/strong>\u092f\u0939\u093e\u0901 \u092a\u0930 \u0906\u092a \u0911\u0930\u094d\u0921\u0930 \u092c\u093e\u092f \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0924\u093e\u0915\u093f \u0930\u093f\u0915\u0949\u0930\u094d\u0921 \u0938\u093f\u0932\u0947\u0915\u094d\u0936\u0928\u00a0 \u0906\u0938\u093e\u0928\u0940 \u0939\u094b\u0964\u00a0<\/p>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/NfgKFzr__Ck\" target=\"_blank\" rel=\"noopener\">Related Video : MySQL Limit With SELECT, UPDATE, DELETE<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.sl.SQL_Logic\" target=\"_blank\" rel=\"noopener\">MySQL&nbsp; \u0938\u0940\u0916\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0928\u0947 \u090f\u0915 SQL Logic \u0928\u093e\u092e \u0938\u0947 \u090f\u0915 \u090f\u0902\u0921\u094d\u0930\u093e\u0907\u0921 \u090f\u092a\u094d\u092a \u092d\u0940 \u092c\u0928\u093e\u0908 \u0939\u0948\u0902 \u0906\u092a \u092f\u0939\u093e\u0901 \u0938\u0947 \u0921\u093e\u0909\u0928\u0932\u094b\u0921 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/selfimagination.in\/tips\/mysql-tutorial-basic-n-advance\/\">\u092e\u0941\u0916\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u092a\u0930 \u091c\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SELECT \u0915\u0947 \u0938\u092d\u0940 ARGUMENT \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 SELECT \u091c\u092c \u092d\u0940 \u0939\u092e\u0947 \u0915\u094b\u0908 \u092d\u0940 Function \u092f\u093e \u0915\u094b\u0908 Calculation \u0915\u0930\u0928\u093e \u0939\u0948\u0902 \u091c\u093f\u0938\u092e\u0947 \u0915\u0940 \u0939\u092e \u0915\u093f\u0938\u0940 Table \u0915\u0940 \u091c\u0930\u0942\u0930\u0924 \u0928\u0939\u0940\u0902 \u0939\u094b \u0924\u092c \u0939\u092e \u0915\u0947\u0935\u0932 Select \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u0930 Result \u0932\u0947 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 SELECT&nbsp;* (Display All Columns of Table \/ Tables) \u0915\u093f\u0938\u0940 \u092d\u0940 \u091f\u0947\u092c\u0932 \u092e\u0947\u0902 \u091c\u094b \u0939\u092e\u0947\u0902 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":587,"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-577","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\/02\/imagination-mysql-select.png?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/577","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=577"}],"version-history":[{"count":56,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/577\/revisions"}],"predecessor-version":[{"id":9528,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/577\/revisions\/9528"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/587"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=577"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=577"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=577"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}