已知一张表student存储在HBase中，查找student表中id:2015001的{score:math｝成绩，其id作为行键，正确的命令是
A: get 'student', '2015001', 'score:math
B: get 'student', '2015001', {COLUMN=>'score:math'}
C: get 'student', '2015001', {COLUMN='score:math'}
D: get 'student', '2015001', {'score:math'}
A: get 'student', '2015001', 'score:math
B: get 'student', '2015001', {COLUMN=>'score:math'}
C: get 'student', '2015001', {COLUMN='score:math'}
D: get 'student', '2015001', {'score:math'}
举一反三
- 中国大学MOOC: 已知一张表student存储在HBase中，向表中插入一条记录{id:2015001,name:Mary,{score:math}:88}，其id作为行键，其中，在插入数学成绩88分时，正确的命令是
- 修改student表中学号为2015001的学生的姓名为“张三” A: update student set sname=’ 张三’ where sid=’2015001’ B: alter table student alter sname=’ 张三’ where sid=’2015001 C: update student set sname=”张三” where sid=’2015001’ D: update student set sname=张三 where sid=’2015001’
- 修改student表中学号为2015001的学生的姓名为“张三”，语句是（）。 A: update student set sname=’ 张三’ where sid=’2015001’ B: update student set sname=张三 where sid=’2015001’ C: update student set sname=”张三” where sid=’2015001’ D: alter table student alter sname=’ 张三’ where sid=’2015001’
- 下列选项中,能够按照 score 由高到低显示 student 表中记录的 SQL 语句是 A: SELECT* FROM student ORDER BY score ; B: SELECT* FROM student ORDER BY score ASC ; C: SELECT * FROM student ORDER BY score DESC ; D: SELECT* FROM student GROUP BY score DESC ;
- 从student表中查询学生姓名、年龄和成绩，结果按照年龄降序排序，年龄相同的按照成绩升序排序，下面SQL语句正确的是： A: select name, age, score from student order by age desc , score; B: select name, age, score from student order by age , score asc; C: select name, age, score from student order by 2 desc , 3 asc; D: select name, age, score from student order by 1 desc , 2；