各位大佬,我有個問題
我有個select * from tb1 where tag IN(select DISTINCT(tag) from tb1 ) 這樣一條sql
我的子查詢里回傳了10條資料,但我想要最新的三條,我試過如下sql
select * from tb1 where tag IN(select DISTINCT(tag) from tb1 order by tag DESC limit 3 ) 報錯如下
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
有辦法實作子查詢里面的的結果集是最新的三行嗎?
轉載請註明出處,本文鏈接:https://www.uj5u.com/shujuku/269714.html
標籤:MySQL
