Código SQL [-] select distinct datepart(year, fecha) from pedidos order by fecha
select distinct datepart(year, fecha) from pedidos order by fecha
Código SQL [-] select * from pedidos where datepart(year, fecha) ='2006' order by fecha
select * from pedidos where datepart(year, fecha) ='2006' order by fecha