Re: [sqlite] 2D query

2017-12-13 Thread Richard Hipp
On 12/13/17, Valentin Davydov wrote: > Given the following table: > > CREATE TABLE people(name,sex); > INSERT INTO people VALUES("Alex","F"); > INSERT INTO people VALUES("Alex","M"); > INSERT INTO people VALUES("Jane","F"); > INSERT INTO people VALUES("John","M"); > > How to construct a query whic

Re: [sqlite] 2D query

2017-12-13 Thread David Raymond
r 13, 2017 8:57 AM To: SQLite mailing list Subject: [sqlite] 2D query Hi, all! Given the following table: CREATE TABLE people(name,sex); INSERT INTO people VALUES("Alex","F"); INSERT INTO people VALUES("Alex","M"); INSERT INTO people VALUES("Jane"

[sqlite] 2D query

2017-12-13 Thread Valentin Davydov
Hi, all! Given the following table: CREATE TABLE people(name,sex); INSERT INTO people VALUES("Alex","F"); INSERT INTO people VALUES("Alex","M"); INSERT INTO people VALUES("Jane","F"); INSERT INTO people VALUES("John","M"); How to construct a query which returns coalesced sex but individual names