oracle查詢(xún)不區(qū)分大小寫(xiě) 如何在SQL模糊查詢(xún)中忽略對(duì)大小寫(xiě)字符的處理?
如何在SQL模糊查詢(xún)中忽略對(duì)大小寫(xiě)字符的處理?最簡(jiǎn)單的子查詢(xún):select * from table where date = (select max(date) from table)或者用輪子哥講
如何在SQL模糊查詢(xún)中忽略對(duì)大小寫(xiě)字符的處理?
最簡(jiǎn)單的子查詢(xún):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