oracle数据库查询别名注意事项

select t.DAILY_ID as "dailyId",(select max(d.col_data) from tbl_oa_daily_data d where t.daily_id=d.daily_id) as "dailyData",
		t.USER_ID as "userId",t.TABLE_ID as "tableId",to_char(t.DAILY_TIME,'yyyy-mm-dd hh24:mi:ss') as "dailyTime",
		(select count(1) from tbl_oa_daily_receiver r where t.daily_id=r.daily_id and r.is_read='0') as "readCount",
		t.STATUS as "status",bu.user_name as "userName",dt.table_name as "tableName" from TBL_OA_DAILY t 
		left join tbl_base_user bu on t.user_id=bu.user_id
		left join tbl_oa_daily_table dt on t.table_id=dt.table_id
		<if test="isRead != null and isRead !=''.toString()">
    		left join tbl_oa_daily_receiver dr on t.daily_id = dr.daily_id
		order by t.daily_time DESC

查询字段别名不带双引号会识别为大写，如果需要小写则需要双引号

select max(d.col_data) from tbl_oa_daily_data d where t.daily_id=d.daily_id order by xx)

注意此处已去最大某值，不能用order by