Question: I have a table with a row "duration" of type `double` (I also tried decimal and float with same result).

When I now insert a row with:

```
INSERT INTO `wp_mytable`(<...>, `duration`) VALUES (<...>, 0.5)

```

everything is entered correctly but instead of `0.5` I get `0`. And if I use `1.5` I get `1` and so on.

The same happens when I edit the row manually and enter `0.5` as value for that row.

I tried entering `'0.5'` instead of `0.5` and since I'm from Germany I also tried using a comma instead of a period, but that had the same effect.

How do I have to enter it?

Answer: 
Try using `GROUP_CONCAT` with a `CASE` expression to target each of the sensor data.

```
SELECT
    fkey,
    GROUP_CONCAT(CASE WHEN sensor=1 THEN value END ORDER BY depth) AS sensor1_values,
    GROUP_CONCAT(CASE WHEN sensor=2 THEN value END ORDER BY depth) AS sensor2_values
FROM yourTable
GROUP BY fkey;

```
Try this query, by replacing table name and column name

fkey is column A | sensor is column B | depth is is column C | value is column D

```
select A, STUFF((SELECT ', ' + D FROM tableA b 
           WHERE b.A = a.A AND b.B = 1
          FOR XML PATH('')), 1, 2, '') sensor1_values  
          , STUFF((SELECT ', ' + D FROM tableA b 
           WHERE b.A = a.A AND b.B = 2
          FOR XML PATH('')), 1, 2, '') sensor2_values
from tableA a
group by A

```