ทดสอบการคำนวณเงินปันผลประจำปี
|
SELECT
*
FROM
sm_mem_m_share_holding_detail share_detail
WHERE
1 = 1
AND share_detail.membership_no = ''
AND YEAR(share_detail.operate_date) = 2023
AND share_detail.operate_date = (SELECT
MAX(sm_mem_m_share_holding_detail.operate_date) AS operate_date
FROM
sm_mem_m_share_holding_detail
WHERE
1 = 1
AND share_detail.membership_no = ''
AND YEAR(operate_date) = 2023)