Skip to content

Instantly share code, notes, and snippets.

@neilmiddleton
Created October 17, 2012 10:28
Show Gist options
  • Save neilmiddleton/3904863 to your computer and use it in GitHub Desktop.
Save neilmiddleton/3904863 to your computer and use it in GitHub Desktop.
create table johns_problem as
select distinct trim(name) as name
from drugs
where customer_id IS NOT NULL
order by name;
select distinct name from drugs
-- delete table johns_problem
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment