pg=0chiamo=appelli_lista

Data Appello

Cerca

Aggiungi Appello Refresh

Elenco appelli

SELECT *, DATEDIFF(A.appello_data, '2025-04-30') AS N FROM tbl_esami E JOIN tbl_appelli A ON A.esame_id = E.esame_id JOIN tbl_users U ON U.user_id = A.appello_id_user_ctu WHERE DATEDIFF(A.appello_data, '2025-04-30') >= 0 ORDER BY A.appello_data, E.esame_nome
select * from ( select a.*, ROWNUM rnum from ( SELECT *, DATEDIFF(A.appello_data, '2025-04-30') AS N FROM tbl_esami E JOIN tbl_appelli A ON A.esame_id = E.esame_id JOIN tbl_users U ON U.user_id = A.appello_id_user_ctu WHERE DATEDIFF(A.appello_data, '2025-04-30') >= 0 ORDER BY A.appello_data, E.esame_nome ) a where ROWNUM <= 30 ) where rnum > 1
Impossibile eseguire sqlAppelli
SELECT *, DATEDIFF(A.appello_data, '2025-04-30') AS N FROM tbl_esami E JOIN tbl_appelli A ON A.esame_id = E.esame_id JOIN tbl_users U ON U.user_id = A.appello_id_user_ctu WHERE DATEDIFF(A.appello_data, '2025-04-30') >= 0 ORDER BY A.appello_data, E.esame_nome

	DATA	ESAME		STATO	RIFERIMENTO CTU