|
發(fā)布時(shí)間: 2016-5-4 08:54
正文摘要:CREATE VIEW dbo.ViewExam AS SELECT 單號(hào), 學(xué)員編號(hào), 姓名, 申請(qǐng)準(zhǔn)駕車(chē)型代號(hào), 班級(jí), 業(yè)務(wù)名稱(chēng), 考試日期, 創(chuàng)建日期, 所屬機(jī)構(gòu), MAX(CASE 考試結(jié)果 WHEN 1 THEN 1 ELSE 0 EN ... |
Powered by Discuz! X3.3 © 2001-2013 Comsenz Inc.