问题遇到的现象和发生背景
问题相关代码,请勿粘贴截图
select YEAR,MONTH, YEAR||MONTH as time, from xx表 where YEAR||MONTH = to_char(current_timestamp, \'YMM\') 现在是获取当前时间 我想要将这条语句改为获取当前表中最大时间的值 应该怎么写语句
select YEAR,MONTH, YEAR||MONTH as time, from xx表 where YEAR||MONTH = to_char(current_timestamp, \'YMM\') 现在是获取当前时间 我想要将这条语句改为获取当前表中最大时间的值 应该怎么写语句
意思是要把所有符合最大时间的数据拉出来吧?
用这个:
select YEAR,MONTH, YEAR||MONTH as time, from xx表 where YEAR||MONTH = (select max(YEAR||MONTH) from xx表)