题目内容

查询一个表中总记录数的SQL语句语法格式是______

A. SELECT COUNT(* )FROM tbl_name ;
B. SELECT COUNT FROM tbl_name ;
C. SELECT FROM COUNT tbl_name ;
D. SELECT * FROM tbl_name :

查看答案
更多问题

办理现金业务的原则?

设有学生表 student ,包含的属性有学号 sno、学生姓名 sname、性别 sex、年龄 age、所在专业 smajor 。 下列语句正确的是 ______

A. SELECT sno, sname FROM student ORDER BY snameUnionSELECT SRO, sname FROM student WHERE smajor="CS";
B. SELECT sno, sname FROM student WHERE sex="M"UnionSELECT Sno, shame, sex FROM student WHERE smajor="CS" ;
C. SELECT sno, sname FROM student WHERE sex="M"ORDER BY snameUnionSELECT sno,sname FROM student WHERE Stupor="CS";
D. SELECT sno, sname FROM student WIlERE sex="M"UnionSELECT sno ,sname FROM student WHERE smajor="CS" ;

大额现金收付授权的要求?

修改表中数据的命令是______

A. UPDATE
B. ALTER TABLE
C. REPAIR TABLE
D. CHECK TABLE

答案查题题库