Select Rownum,
Para_Year,
Holiday_Name,
Holiday_Type,
To_Char(Holiday_Date, 'yyyy-mm-dd') Holiday_Date,
Decode(Work_Day_Type, '+', '是', '-', '否') Work_Day_Type,
Decode(Res, '', '暂无记录', Res) Res
From Holiday_Work
Where 1 = 1
Group By Holiday_Name这样会提示不是一个group-by表达式.原因是我只为Holiday_Name分组了.而其他的没有.
如何才能正确的运行呢?我只想按照Holiday_Name分组.
Para_Year,
Holiday_Name,
Holiday_Type,
To_Char(Holiday_Date, 'yyyy-mm-dd') Holiday_Date,
Decode(Work_Day_Type, '+', '是', '-', '否') Work_Day_Type,
Decode(Res, '', '暂无记录', Res) Res
From Holiday_Work
Where 1 = 1
Group By To_Char(Holiday_Date, 'yyyy-mm-dd')
--你是想求名字相同的中日期最近的一个?
Select Rownum,
Para_Year,
Holiday_Name,
Holiday_Type,
To_Char(Holiday_Date, 'yyyy-mm-dd') Holiday_Date,
Decode(Work_Day_Type, '+', '是', '-', '否') Work_Day_Type,
Decode(Res, '', '暂无记录', Res) Res
From Holiday_Work a
Where 1 = 1 and not exists(select 1 from Holiday_Work b where a.Holiday_Name=b.Holiday_Name and a.Holiday_Date<b.Holiday_Date)
Select Rownum,
Para_Year,
Holiday_Name,
Holiday_Type,
To_Char(Holiday_Date, 'yyyy-mm-dd') Holiday_Date,
Decode(Work_Day_Type, '+', '是', '-', '否') Work_Day_Type,
Decode(Res, '', '暂无记录', Res) Res
From Holiday_Work a
Where 1 = 1 and not exists(select 1 from Holiday_Work b where a.Holiday_Name=b.Holiday_Name and a.Holiday_Date<b.Holiday_Date)
不太理解你想干什么??