oracle查詢不區(qū)分大小寫 如何在SQL模糊查詢中忽略對大小寫字符的處理？
如何在SQL模糊查詢中忽略對大小寫字符的處理？最簡單的子查詢：select * from table where date = (select max(date) from table)或者用輪子哥講
如何在SQL模糊查詢中忽略對大小寫字符的處理？
最簡單的子查詢：select * from table where date = (select max(date) from table)
或者用輪子哥講的join自己：
select * from table t1 left join (select max(date) as date from table) t2 on t1.date=t2.date where t2.date is not null