mi tabla es asi tabla contratacion
Código SQL:
Ver original
|--ID--|---Nombre----|----------Email-----------|-----Password-----|Tiempo_Contratado|Monto|Dia_Contrato |--1---|-----pedro----|[email protected]|--------ponce------| Dia | 25 |13-03-2013 |--2---|-----juan------|[email protected]|--------santos------| Dia | 25 |03-04-2013 |--3---|-----javier-----|[email protected]|-----herrejon------| Dia | 25 |02-04-2013
Mi consulta se me ocurre algo asi
select EMAIL from contratacion where DIA_CONTRATADO <= 3 dias

dada mi consulta deberia de obtener solo estos registros
[email protected] -----+---- [email protected]