for example:
-------------------------
| ID | Date | Name |
-------------------------
| 1 | 2018-01-03 | Name 1 |
| 2 | 2018-01-03 | Name 2 |
| 3 | 2018-01-04 | Name 3 |
I want Output like this:
Name 1<br>
Name 2<br>
<br>
Name 3
for example:
-------------------------
| ID | Date | Name |
-------------------------
| 1 | 2018-01-03 | Name 1 |
| 2 | 2018-01-03 | Name 2 |
| 3 | 2018-01-04 | Name 3 |
I want Output like this:
Name 1<br>
Name 2<br>
<br>
Name 3
What do you mean? Output fields according to different values? If so, you can do this:
select name from table group by date