Advertisement
Marcos_Carvalho

banco de dados

Mar 28th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. create table funcionario (
  2.  
  3. cpf int,
  4. nome varchar(62),
  5. data_nasc date,
  6. salario float
  7.  
  8. );
  9.  
  10. in sert into funcionarios values
  11. (734, gabriela, 10091996, 7000);
  12. update funcionarios set salario = 700 where cpf 5435435.
  13.  
  14.  
  15.  
  16. algebra relacional.
  17. operador SELECT
  18.  
  19. WERE= CONDICAO
  20. SELECT * FROM FUNCIONARIO WHERE SALARIO = 5000
  21. SE QUISER OS NOMES DO QUE SAO ACIMA DE: SELECT FROM NOMES WHERE SALARIO > 5000
  22. W3Schools, SQL - https//www.w3schools.com/sql/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement