若将所有学生的年龄增加1岁,下列哪一个语句是正确的?( )
A: UPDATE Student.Sage SET Sage = 1+Sage;
B: UPDATE Student SET Sage = Sage + 1;
C: UPDATE Student.Sage SET Sage = Sage + 1;
D: UPDATE Student.* FROM Student SET Sage = Sage + 1;
A: UPDATE Student.Sage SET Sage = 1+Sage;
B: UPDATE Student SET Sage = Sage + 1;
C: UPDATE Student.Sage SET Sage = Sage + 1;
D: UPDATE Student.* FROM Student SET Sage = Sage + 1;
举一反三
- 将所有计算机系学生的年龄增加1岁的正确语句是:( )。 A: UPDATE SET Student.Sage = Student .Sage + 1 WHERE Student.Sdept = 'CS'; B: UPDATE Student SET Sage + 1 WHERE Sdept = 'CS'; C: UPDATE Student SET Sage =Sage + 1 WHERE Sdept = 'CS'; D: UPDATE Student SET Sage += 1 WHERE Sdept = 'CS';
- 使用STC数据库,将所有计算机系学生的年龄增加1岁的正确语句是( )。 A: UPDATE SET Student.Sage = Student .Sage + 1 WHERE Student.Sdept = 'CS'; B: UPDATE Student SET Sage + 1 WHERE Sdept = 'CS'; C: UPDATE Student SET Sage = Sage + 1 WHERE Sdept = 'CS'; D: alter table student alter column sage=sage+1
- 命令:UDPATE student SET sage = sage + 1,描述正确的是()
- 现要利用Student(sno, sname, ssex, sage, sdept)表查询年龄最小的学生的姓名和年龄。下列实现此功能的查询语句正确的是( )。 A: SELECT sname, Min( sage )from student B: SELECT sname ,sage from student where sage=Min( sage ) C: SELECT TOP 1 Sname , Sage From student D: SELECT TOP 1 sname , sage from student order by sage
- 现要利用Student表查询年龄最小的学生的姓名和年龄。下列实现此功能的查询语句中,正确的是______。 A: SELECT Sname, MIN(Sage) FROM Student B: SELECT Sname, Sage FROM Student WHERE Sage = MIN(Sage) C: SELECT TOP 1 Sname, Sage FROM Student D: SELECT TOP 1 Sname, Sage FROM Student ORDER BY Sage