我试图通过比较帐户ID的最后数字和最后一个数字来选择几个帐户
Error 3706] [SQLState 42000] Syntax error: expected something between the 'select' keyword and the 'MOD' keyword.
这是我的查询
SELECT TOP 10 acct.accoun_id FROM accounts WHERE current_date mod 10 = select MOD 10(account_id)
这听起来像是一件非常奇怪的事情。假设account_id
是一个数字,您想要一日的日子,那么:
SELECT TOP 10 a.accoun_id
FROM accounts a
WHERE EXTRACT(day FROM CURRENT_DATE) MOD 10 = a.account_id MOD 10;