bbs.hsiao.net 交流論壇

Code: Select all

 SELECT name,nop,(nop+1) AS subtotal FROM Wedding.Wedding_Registration
 UNION
 SELECT NULL,NULL,SUM(subtotal)
 FROM (SELECT name AS n1,nop AS n2,(nop+1) AS subtotal FROM Wedding.Wedding_Registration) AS T1 GROUP by n1;

Code: Select all

'Chang-An Hsiao', 0, 1
'', , 1

Code: Select all

CREATE VIEW `Wedding`.`Guest_Registration_View` AS
 SELECT name,nop,(nop+1) AS subtotal FROM Wedding_Registration
 UNION
 SELECT NULL,NULL,SUM(subtotal)
 FROM (SELECT name AS n1,nop AS n2,(nop+1) AS subtotal FROM Wedding_Registration) AS T1 GROUP by n1;