Advertisement
Guest User

query

a guest
Jul 8th, 2019
241
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. create table export (
  2.     gsm text,
  3.     motivo_envio text,
  4.     status text
  5. );
  6.  
  7. insert into export values
  8. ('111', 'aaa', 'LIBERADO'),
  9. ('111', 'aaa', 'ANOMALIA'),
  10. ('111', 'bbb', 'PENDENTE'),
  11.  
  12. ('222', 'aaa', 'ANOMALIA'),
  13. ('222', 'bbb', 'PENDENTE'),
  14.  
  15. ('333', 'aaa', 'ANOMALIA'),
  16. ('333', 'bbb', 'ANOMALIA'),
  17.  
  18. ('444', 'aaa', 'DEFINITIVA'),
  19. ('444', 'bbb', 'ANOMALIA'),
  20.  
  21. ('555', 'bbb', 'LIBERADO'),
  22. ('555', 'aaa', 'ANOMALIA'),
  23. ('555', 'bbb', 'ANALISE'),
  24.  
  25. ('666', 'aaa', 'LIBERADO'),
  26. ('666', 'bbb', 'ANOMALIA'),
  27. ('666', 'ccc', 'ANOMALIA'),
  28. ('666', 'ccc', 'PENDENTE'),
  29. ('666', 'ddd', 'ANOMALIA')
Advertisement
RAW Paste Data Copied
Advertisement