sql 增加一列 

WITH TeamMascot AS
 (SELECT 50 as SchoolID, 'Jaguars' as Mascot UNION ALL
  SELECT 51, 'Knights' UNION ALL
  SELECT 52, 'Lakers' UNION ALL
  SELECT 53, 'Mustangs')
SELECT * ,(select 3) as add_column_1, (select 6) as add_column_2,  FROM TeamMascot

在这里插入图片描述

posted @ 2022-08-19 22:51  luoganttcc  阅读(4)  评论(0)    收藏  举报