... CONCAT(q'$'0'$',KVARTAL*3 - 3) ...
где встречается символ $
. ||
? (как сделано выше в вашем коде)$
? Тут должна быть переменная.... CONCAT(q' ||variable||'0'||variable||',KVARTAL*3 - 3) ...
select sum(rashody) over(partition by gosb) /
count(*) over(partition by gosb)
from erp_trips;
SELECT id FROM (SELECT id, ROW_NUMBER() OVER (PARTITION BY id ORDER BY id) AS row_num FROM dle_post) t WHERE row_num > 1;
DELETE FROM dle_post
WHERE id IN (SELECT id FROM (SELECT id, ROW_NUMBER() OVER (PARTITION BY id ORDER BY id) AS row_num FROM dle_post) t WHERE row_num > 1);
CREATE UNIQUE INDEX dle_post_id_unq ON dle_post(id);