Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2019
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. Select *
  2. From consulta
  3. Where month (cons_data) =9 and year (cons_data)='2019';
  4.  
  5. Select pac_nome,pac_genero,pac_dist_id,pac_dataNasc
  6. From Paciente
  7. Where Pac_genero like 'M' and pac_dist_id =1
  8. order by pac_DataNasc;
  9.  
  10.  
  11. select pac_nome,pac_genero,pac_dist_id,pac_DataNasc
  12. From Paciente
  13. Where pac_dist_id <>2
  14. Order by pac_nome asc, pac_genero desc;
  15.  
  16. Select *
  17. From Paciente
  18. Where pac_bi is not null and pac_cronic = true
  19. order by pac_nome desc;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement