SQL Êý¾Ý¿âÖ®Ò»

1.      SELECT
ʵÀý105
SELECT ID "±àºÅ",Name ÐÕÃû,
       Math_Score 'Êýѧ³É¼¨',  //ÔõôÓеÄÓÐAS,ÓеÄûÓÐ
       Music_Score AS ÒôÀֳɼ¨,
       English_Score AS Ó¢Îijɼ¨
from tb_StuScore
 
SELECT ±àºÅ, ÉÌÆ·Ãû³Æ,ÊýÁ¿,µ¥¼Û,½ø¼Û,
(µ¥¼Û*ÊýÁ¿) AS ÏúÊÛ¶î,
(µ¥¼Û*ÊýÁ¿-½ø¼Û*ÊýÁ¿) AS ÀûÈó
from tb_xsb
 
SELECT ID,Name,Math_Score,Music_Score,EngLish_Score
from tb_StuScore
WHERE NOT (EngLish_Score>= 90) OR (Math_Score>=95)
 
SELECT *
from tb_StuScore
WHERE Math_score LIKE '8_'
 
SELECT *
from tb_StuScore
WHERE Name  LIKE 'Áõ%'
 
SELECT *
from tb_StuScore
WHERE English_score LIKE '9[5-9]%'
 
SELECT *
from tb_StuScore
WHERE Math_Score LIKE '[^9][0-9]'
 
SELECT *
from tb_StuScore
WHERE (Name LIKE 'Áõ%')
       AND (
            (Math_Score LIKE '[^7]_')
             OR (EngLish_score LIKE '9[0-9]')
            )
 
SELECT 'ÐÕÃû£º'+ Name + '£»±àºÅ£º'+
         CONVERT(varchar(3),id) AS ѧÉúÐÅÏ¢
from tb_StuScore
 
SELECT ÐÕÃû,LTRIM(ÐÕÃû) AS È¥³ý×óÃæ¿Õ¸ñ,
        RTRIM(ÐÕÃû) AS È¥³ýÓÒÃæ¿Õ¸ñ,
        LTRIM(RTRIM(ÐÕÃû)) AS È¥³ý×óÓÒ¿Õ¸ñ
from   ¿Í»§ÐÅÏ¢±í
 
SELECT *
from tb_StuScore
WHERE  Music_Score IN (85,95,100)
 
SELECT *
from tb_StuScore
WHERE Music_Score NOT IN (85,95,100)
 
SELECT *
from tb_StuScore
WHERE Music_Score > ALL
       ( SELECT Music_Score
         from tb_StuScore
         WHER