ممنون مشکل حل شد





SELECT DISTINCT

	max( date ) AS date,

	materialname,

	measurementunit,

	price,

	moneytype 

FROM

	`tbl_ingredientprices` 

WHERE

	date <= '1396/10/08' 

GROUP BY

	materialname