'How do i SQL query to display results by one item and all attributes or details each
Lets Assume i have a table like this,
| id | serialnum | description | date |
|---|---|---|---|
| 112 | 56345256 | Gone | 0109 |
| 113 | 56345675 | Home | 0110 |
| 114 | 56345256 | Gone | 0110 |
| 115 | 56345434 | Home | 0109 |
| 116 | 56345256 | Home | 0112 |
| 117 | 56345434 | Away | 0113 |
| 118 | 56345256 | Gone | 0112 |
| 119 | 56345434 | Home | 0109 |
| 120 | 56345256 | Gone | 0113 |
| 121 | 56345675 | Away | 0111 |
| 122 | 56345256 | Away | 0107 |
How Do i write an SQL query to display each serialnum and all descriptions and dates in groups. an example the serialnum '56345256';
| description | date |
|---|---|
| Gone | 0109 |
| Gone | 0110 |
| Home | 0112 |
| Gone | 0112 |
| Away | 0107 |
then the others follow, each serial number and all the describtions and info under it.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|