求问有关SQL查询的问题

[modishizhe1]

表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 TABLE

[csdnFUCKINGSUCKS]

SELECT MAX(Score) AS MAXSCORE, MIN(Score) AS MINSCORE,0 AS TEACHSCORE, Score AS SCORE,'' AS REMARK FROM test GROUP BY Score

[nopingno]

SELECT MAX(Score) AS MAXSCORE, MIN(Score) AS MINSCORE,0 AS TEACHSCORE, Score,'' AS REMARK FROM TABLE GROUP BY Score

[昵称90天可改一次]

select MAXSCORE=0， MINSCORE=0， TECHSCORE=0， SCORE REMARK=NULL from TABLE

[昵称90天可改一次]

select MAXSCORE=0， MINSCORE=0， TECHSCORE=0， SCORE, REMARK=NULL from TABLE 少写个，

[EnForGrass]

score类型应该不是nvarvhar等吧 这样 SELECT 0 AS MAXSCORE, 0 AS MINSCORE, 0 AS TECHSCORE, SCORE, '' AS REMARK FROM TABLE

[mansheng]

引用 1 楼 ducker3590 的回复:

SELECT MAX(Score) AS MAXSCORE, MIN(Score) AS MINSCORE,0 AS TEACHSCORE, Score AS SCORE,'' AS REMARK FROM test GROUP BY Score

根据这位哥的写法没错得。