oracle查询不区分大小写如何在SQL模糊查询中忽略对大小写字符的处理？

2021-03-10

2265

如何在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