摘要:
sql语句重新又学习一遍看看自己有那些语句是自己遗忘了的或者说是自己不会的sql语句,重新在学习一遍,通过牛客网刷题的方式进行巩固。 1.注意:原表数据不会被修改,只是查询结果去重。 去重需要使用一个关键字:distinct SELECT distinct university FROM user_ 阅读全文
摘要:
SELECT * FROM DM_K_S_PROFIT WHERE COMPANY = '1210' AND YEARS = '2021' AND MONTHS = '11' AND ID = UPPER(ID) DELETE FROM DM_K_S_PROFIT WHERE COMPANY = ' 阅读全文
摘要:
UPDATE DM_K_S_CASH_FLOW t SET t.CURRENT_ADJUSTMENT_AFERT = '0' WHERE t.CURRENT_ADJUSTMENT_AFERT IS NULL AND t.COMPANY = '1210' AND t.MONTHS = '11' AND 阅读全文