SELECT name, address
CASE behaviour
WHEN 'nice' THEN SELECT toy FROM stocking_stuffers ORDER BY random() LIMIT 1
WHEN 'naughty' THEN 'coal'
ELSE phnglui mgwlnafth cthulhu
END
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
On 14 December 2017 at 01:19, Warren Young wrote:
> On Dec 12, 2017, at 10:24 AM, Simon Slavin wrote:
> >
> > Santa Clause: SELECT name,hobbies,address FROM people WHERE
> behaviour=‘nice’
>
> I think you mean
>
> SELECT name,address
> CASE
On Dec 12, 2017, at 10:24 AM, Simon Slavin wrote:
>
> Santa Clause: SELECT name,hobbies,address FROM people WHERE
> behaviour=‘nice’
I think you mean
SELECT name,address
CASE behaviour
WHEN ‘nice' THEN
hobbies
ELSE
'coal'
You had to do that just beclause
On Tue, Dec 12, 2017 at 12:24 PM, Simon Slavin wrote:
> Some SQL terminology:
>
> Selection Clause: WHERE
>Sort Clause: ORDER BY
> Sublist Clause: LIMIT OFFSET
> Subsort Clause: GROUP BY HAVING
> Santa
4 matches
Mail list logo