On Tue, 12 Feb 2019 13:31:59 +0100
Clemens Ladisch wrote:
> SQLite allows to SELECT columns that are not mentioned in the GROUP
> BY clause, but they get their values from a random row in the group.
Thank you for pointing this out! I was aware of the row being
random when selected this way, but
On Tue, 12 Feb 2019 14:08:20 +0200
R Smith wrote:
> The semantics are made more legible using a CTE here, but can be
> done without it. The essential difference is that it uses a sub-query
> to obtain the minimum priority as opposed to introducing a sub-table
> sort.
Thank you for your reply!
Hi!
I have a table of some values obtained from different sources:
create table test (
id, source_id, value,
primary key(id, source_id)
);
insert into test values
(1, 1, 11), (1, 2, 12), (1, 3, 13),
(2, 1, 21),
(3, 2, 32);
When SELECTing the values, I
3 matches
Mail list logo