php echo $dept;?>&fy=<?php echo $selectedFy;?php } ?$getData = mysql_query("SELECT SUM(hire_net) as rentalRev FROM dw_invoice LEFT JOIN dw_rep_zips ON dw_invoice.zip= dw_rep_zips.zip WHERE contract_type='H
我正在尝试使用带内连接的hibernate查询语言在mySQL DB中查找日期列的最大值
@Query("select u, CAST(MAX(o.last_modified AS DATE)) fromcom.dw.model.user.User as u left join com.dw.domain.order.Order as o on u.username=o.techid group byexpecting CLOSE, found 'AS' near line 1, column