sql

Sql code posted by William
created at 17 Oct 14:45, updated at 29 Oct 20:09

Edit | Back 
1
2
3
4
5
 
CREATE DATABASE test;
SELECT nome as "Nome", cpf as "CPF", CASE WHEN data = current_date() THEN 'FULANO' ELSE 'CICLANO' END AS "Abla"
FROM pessoas
WHERE rg IS NOT NULL
174 Bytes in 2 ms with coderay