This tag is related to SQL window functions
Questions tagged [over-clause]
32 questions
-1
votes
1 answer
For one employee, In time and Out time should be returned on one line
select
compcode, emplcode, attndate, costcode,
decode(shiftflg, 'I', readtime) INTIME,
decode(shiftflg, 'O', readtime) OUTTIME
from
ecatnrec
where
emplcode = 'RF025'
order by
emplcode;
Prabha Christ
- 131
- 2
- 2
- 10
-3
votes
1 answer
Cannot use the "over" clause with MySQL workbench 8.0 (MySQL version 5.7.31)
I struggle to see what I'm doing wrong. I have noticed that some syntax doesn't work (I've had this issue with the keywords "WITH" and now with "OVER".
I am applying a windowing function on a table with the columns id, price and cluster. I want to…
ml_chai
- 61
- 5