SQLite Forum

Invalid group by usage?
Login
From the rows in the table, I don't know how `-11` could select a row.

````
sqlite> .mode column
sqlite> .headers on
sqlite> select * from table_10_undef_undef;
pk  col_bigint_signed  col_float_signed  col_double_signed  col_char(20)_signed  col_varchar(20)_signed  col_tinyint_signed  col_smallint_signed
--  -----------------  ----------------  -----------------  -------------------  ----------------------  ------------------  -------------------
0   -9.183             12.991            0.0                you                                          a                   c
1   -9553              1.0               -9.183             w                                            back                not
2   1                  -1.0              0.0                                     x                       q
3   -8                 0.0               0.0                                     is                      b
4   18                 0.0               12.991             r                    w                       p
5   117                12.991            1.009              c                                            v                   will
6   18.0266            -1.0              -9.183             can                  okay                                        i
7   12.991             1.0               -121.0             w                                                                j
8   -9.183             100.0             -9.183             right                g                       o                   a
9   100                                  12.991             s                                            r                   want
````