表TABLE 有字段ID,SCORE
想要从里面取出字段MAXSCORE MINSCORE TECHSCORE SCORE REMARK,只有SCORE是实际存在的,MAXSCORE MINSCORE TECHSCORE 取出时默认为0,REMARK为空
现在SQL语句这么写,不知道有没有问题:
SELECT N'0' AS MAXSCORE, N'0' AS MINSCORE, N'0' AS TECHSCORE, SCORE, N'' AS REMARK FROM TABLESQL查询
想要从里面取出字段MAXSCORE MINSCORE TECHSCORE SCORE REMARK,只有SCORE是实际存在的,MAXSCORE MINSCORE TECHSCORE 取出时默认为0,REMARK为空
现在SQL语句这么写,不知道有没有问题:
SELECT N'0' AS MAXSCORE, N'0' AS MINSCORE, N'0' AS TECHSCORE, SCORE, N'' AS REMARK FROM TABLESQL查询
少写个,
这样
SELECT 0 AS MAXSCORE, 0 AS MINSCORE, 0 AS TECHSCORE, SCORE, '' AS REMARK FROM TABLE