Skip to content

Instantly share code, notes, and snippets.

@tdunning

tdunning/gist:d1970aec133e96fe4c8cbb4515ecb8aa

Created March 16, 2023 01:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tdunning/d1970aec133e96fe4c8cbb4515ecb8aa to your computer and use it in GitHub Desktop.
Save tdunning/d1970aec133e96fe4c8cbb4515ecb8aa to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Pragma version;
CREATE TABLE distributors (
did integer CHECK (did > 100),
name varchar(40)
);
insert into distributors values (200, 'a');
insert into distributors values (201, 'b');
select min(columns('d.*')) from distributors;
select * exclude did from distributors;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment