How to group data so that they follow each other?

Question

Database

There is a database with the following columns:

I want to display number1, title, theme and idea one after the other, and then group by subjectname. Like this:
number1 1 title titlename theme themename idea ideaname
number1 2 title titlename theme themename idea ideaname
number1 3 title titlename theme themename idea ideaname
Subjectname subject1
Subjectname subject2
Subjectname subject3
Subjectname subject4
Subjectname subject5

Answer 1

First you need to group the data GROUP BY , and then sort ORDER BY
Example:

SELECT number1, title, theme, idea 
  FROM units 
 GROUP BY number1, title, theme, idea
 ORDER BY number1 ASC