我有以下專欄
extract_dt
------------
2022-02-06 |
2022-02-06 |
2022-02-06 |
2022-02-06 |
2022-02-06 |
2022-02-06 |
2022-02-06 |
2022-01-30 |
2022-01-30 |
2022-01-30 |
2022-01-30 |
2022-01-23 |
2022-01-23 |
2022-01-23 |
2022-01-23 |
2022-01-23 |
2022-01-23 |
我只想自動獲取具有最近兩個日期的資料，因為每周都會執行一次新的提取并在列中輸入新的日期。
我嘗試使用它，但沒有成功。
SELECT distinct top(2) extract_dt
FROM table
ORDER BY extract_dt desc
并得到以下錯誤
AnalysisException: Syntax error in line 263: where extract_dt = SELECT distinct top(2) extract_dt ^ Encountered: SELECT Expected: CASE, CAST, EXISTS, FALSE, IF, INTERVAL, NOT, NULL, TRUNCATE, TRUE, IDENTIFIER CAUSED BY: Exception: syntax error
我也試過
SELECT MAX(extract_dt)
FROM table
WHERE extract_dt NOT IN (SELECT Max (extract_dt)
FROM table);
回傳以下錯誤
AnalysisException: Syntax error in line 263: SELECT MAX(extract_dt) ^ Encountered: SELECT Expected: AND, AS, ASC, BETWEEN, CROSS, DESC, DIV, ELSE, END, FOLLOWING, FROM, FULL, GROUP, IGNORE, HAVING, ILIKE , IN, INNER, IREGEXP, IS, JOIN, LEFT, LIKE, LIMIT, LOCATION, NOT, NULLS, OFFSET, ON, OR, ORDER, PRECEDING, RANGE, REGEXP, RIGHT, RLIKE, ROWS, SET, STRAIGHT_JOIN, THEN, UNION , USING, WHEN, WHERE, COMMA, IDENTIFIER CAUSED BY: Exception: Syntax error
uj5u.com熱心網友回復：
您可以使用limit：
select distinct extract_dt
from table
order by extract_dt desc
limit 2
uj5u.com熱心網友回復：
另一種解決方案可以是用戶定義的函式。在第一輪中，您將選擇
SELECT Max (extract_dt)
FROM table INTO variable
然后 SELECT AND 與另一個 SELECT 中的值進行比較。
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/431102.html
下一篇：SQL-合并兩個查詢