Advertisement
lll_lll

lista 2 bd

Sep 16th, 2014
217
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.30 KB | None | 0 0
  1. //1
  2. select nome from funcionario
  3. where nome like'%i%' and sexo = 'f'
  4.  
  5. //2
  6. select SUM(valorUnitario) as total
  7. from produto
  8.  
  9. //3
  10. select cpf from funcionario
  11. where year(datanascimento) < 1980
  12.  
  13. //6
  14. select * from funcionario
  15. where (Year(curdate))- year(datanascimento)) > 20 and
  16. salario > 2000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement