WITH X ASSELECT0 ACTIVEMONTH(TERMINATION_DATEMONTH(CURRENT TIMESTAMP) AND YEAR(TERMINATION_DATE) = YEAR(CURRENT TIMESTAMP)
0 TERMINATED,FROM DRIVER WHERE
ACTIVE_
department_id, description FROM departments INTO OUTFILE '/var/lib/mysql-files/departaments.csv' FIELDS TERMINATEDBY ', ' ENCLOSED BY '"' LINES TERMINATED BY '\n';"
谢谢!
下面的选择提供了8524个值的列表。一半是另一半的副本,日期不同。我需要根据新的DateEffective终止旧的值WHERE GETDATE() BETWEEN DateEffective AND DateTerminated GROUP BY PRIDORDER BY PRIDselect * from PRL wh