SQL-lauseita

Tilauksia per tuote per vuosi

select name, count(name) as 'ordercount' from orderproducts where DATEPART(yyyy, received) = '2014' group by name order by 'ordercount' desc;

select name, DATEPART(yyyy, received) as 'year', count(name) as 'ordercount' from orderproducts group by name, DATEPART(yyyy, received) order by year desc, 'ordercount' desc

Tilaukset, tuotteet, käyttäjät (Efecten SAM-tarkistus)

select orders.id, orders.categoryName, orderproducts.name, orderproducts.enduserName, orders.division, orders.costpool, orders.ordered, orders.purchased, REPLACE(REPLACE(orders.comment, CHAR(13), ''), CHAR(10), '')
from orders, orderproducts
where orders.id=orderproducts.order_id