English version (when available)
select * from pedido where fecha < '2010-10-01';
select * from pedido where fecha > '2010-08-31';
select * from pedido where fecha > '2010-07-31' and fecha < '2010-11-01';Solución alternativa:select * from pedido where fecha between '2010-08-01' and '2010-10-30';
select * from pedido where fecha = '2010-03-03' or fecha = '2010-10-27';
select now();
select distinct articulo from linped l, pedido p where l.numpedido=p.numpedido and year(fecha)=2010 order by articulo;Solución alternativa:select distinct articulo from linped l, pedido p where l.numpedido=p.numpedido and fecha between '2010-01-01' and '2010-12-31' order by articulo;
select distinct articulo from linped l, pedido p where l.numpedido=p.numpedido and month(fecha)=3 and year(fecha)=2010 order by articulo;Solución alternativa:select distinct articulo from linped l, pedido p where l.numpedido=p.numpedido and fecha between '2010-03-01' and '2010-03-31' order by articulo;
select * from usuario where month(nacido)=3