你可能感兴趣的试题
=B3*15%+C3*25%+D3*60% =B$3*15%+C$3*25%+D$3*60% =SUM(B3*15%+C3*25%+D3*60%) =SUM(B$3*15%+C$3*25%+D$3*60%)
=COUNT(E3:E10,>=60)和=COUNT(E3:E10,<60) =COUNT(E3:E10,">=60"和=COUNT(E3:E10,"<60") =COUNTIF(E3:E10,>=60)和=COUNTIF(E3:E10,<60) =COUNTIF(E3:E10,">=60")和=COUNTIF(E3:E10,"<60")
从学生成绩表中删除行('0001','001',60) 将行('0102','002',80)插入到学生成绩表中 将学生成绩表中的学生号='0101'的成绩改为60 将学生成绩表中学生号='0103'的学号改为'0104'
=B3*15%+C3*25%+D3*60% =B$3*15%+C$3*25%+D$3*60% =SUM(B3*15%+C3*25%+D3*60%) =SUM(B$3*15%+C$3*25%+D$3*60%)
=COUNT(E3:E10,>=60)和=COUNT(E3:E10,<60) =COUNT(E3:E10,">=60")和=COUNT(E3:E10,"<60") =COUNTIF(E3:E10,>=60)和=COUNTIF(E3:E10,<60) =COUNTIF(E3:E10,">=60")和=COUNTIF(E3:E10,"<60")
=B3*15%+C3*25%+D3*60% =B$3*15%+C$3*25%+D$3*60% =SUM(B3*15%+C3*25%+D3*60%) =SUM(B$3*15%+C$3*25%+D$3水60%)
学生表 学生号 课程名 成绩 0001 001 60 I.0001 J.002 K.80 L. M.0001 N.033 O.56
从学生成绩表中删除行('0001','001',60) 将行('0102','002',80)插入到学生成绩表中 将学生成绩表中学生号='0101'的成绩改为60 将学生成绩表中学生号='0103'的学号改为'0104'
SELECT姓名FROM学生表WHERE EXISTS;
(SELECT学号FROM成绩表WHERE成绩>90) SELECT姓名FROM学生表WHERE EXISTS;
(SELECT学号FROM成绩表WHERE学号=学生表.学号AND成绩>90) SELECT姓名FROM学生表WHERE学号EXISTS;
(SELECT学号FROM成绩表WHERE学号=学生表.学号AND成绩>90) SELECT姓名FROM学生表WHERE学号=;
(SELECT学号FROM成绩表WHERE成绩>90)
=B3*15%+C3*25%+D3*60% =B$3*15%+C$3*25%+D$3*60% =SUM(B3*15%+C3*25%+D3*60%) =SUM(B$3*15%+C$3*25%+D$3*60%)
=B3*15%+C3*25%+D3*60% =B$3*15%+C$3*25%+D$3*60% =SUM(B3*15%+C3*25%+D3*60%) =SUM(B$3*15%+C$3*25%+D$3*60%)
=B3*15%+C3*25%+D3*60% =B$3*15%+C$3*25%+D$3*60% =SUM(B3*15%+C3*25%+D3*60%) =SUM(B$3*15%+C$3*25%+D$3*60%)
=B3*15%+C3*25%+D3*60% =B$3*15%+C$3*25%+D$3*60% =SUM(B3*15%+C3*25%+D3*60%) =SUM(B$3*15%+C$3*25%+D$3*60%)
=B3×15%+C3×25%+D3×60% =B$3×15%+C$3×25%+D$3×60% =SUM(B3×15%+C3×25%+D3×60%) =SUM(B$3×15%+C$3×25%+D$3×60%)
学生表 学生号 课程名 成绩 0001 001 60 I.0001 J.002 K.80 L. M.0101 N.033 O.56