title: sqlite: concatination with records and max of length of that data of each row 53
body: <p>I try to make a query that returns a rows with this data :</p>
  <pre><code>CREATE TABLE stud (stud_id integer primary key, stud_name text not null, stud_email text not null, stud_mark float not null);
  INSERT INTO &quot;main&quot;.&quot;stud&quot; (&quot;stud_id&quot;, &quot;stud_name&quot;, &quot;stud_email&quot;, &quot;stud_mark&quot;) VALUES ('1', 'Jay', 'jay@gmail.com', '90.0');
  INSERT INTO &quot;main&quot;.&quot;stud&quot; (&quot;stud_id&quot;, &quot;stud_name&quot;, &quot;stud_email&quot;, &quot;stud_mark&quot;) VALUES ('3', 'Jenny', 'jenny@gmail.com', '70.0');
  INSERT INTO &quot;main&quot;.&quot;stud&quot; (&quot;stud_id&quot;, &quot;stud_name&quot;, &quot;stud_email&quot;, &quot;stud_mark&quot;) VALUES ('2', 'Johan', 'jon@gamil.com', '85.0');
  INSERT INTO &quot;main&quot;.&quot;stud&quot; (&quot;stud_id&quot;, &quot;stud_name&quot;, &quot;stud_email&quot;, &quot;stud_mark&quot;) VALUES ('5', 'Pooja', 'pooja@gamil.com', '50.0');
  INSERT INTO &quot;main&quot;.&quot;stud&quot; (&quot;stud_id&quot;, &quot;stud_name&quot;, &quot;stud_email&quot;, &quot;stud_mark&quot;) VALUES ('4', 'Sameer', 'sam@gmail.com', '63.0');
  </code></pre>
  <p><a href="https://i.stack.imgur.com/oe1jh.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oe1jh.png" alt="enter image description here" /></a></p>
  <p>I try to use WITH RECURSIVE and GROUP_CONCAT but I did not where can I put the max of data as 53 to get mutlti rows.</p>
  <pre><code>WITH RECURSIVE TMP(N1) AS ( 
  SELECT  GROUP_CONCAT(stud_id || &quot;*&quot; || stud_name || &quot;*&quot; || stud_email || &quot;*&quot; || stud_mark,&quot;?&quot;)  
  FROM STUD ) 
  SELECT N1
  FROM TMP
  </code></pre>
  <p><a href="https://i.stack.imgur.com/cEf5J.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cEf5J.png" alt="enter image description here" /></a></p>
  <p>Please, can you help me to find a solution to get a query that can return the data like this:</p>
  <p>with making a concatination with a records until the a <strong>max</strong> of length of that data of each row as <strong>53</strong></p>
  <pre><code>1*Jay*jay@gmail.com*90.0?2*Johan*jon@gamil.com*85.0
  3*Jenny*jenny@gmail.com*70.0
  5*Pooja*pooja@gamil.com*50.0
  4*Sameer*sam@gmail.com*63.0
  </code></pre>
  <p>Best regards</p>