题目内容:
在表ticket中查询所有票价小于100元的车次、始发站和终点信息的命令是A)SELECT *FROM ticket WHERE票价<100B)SELECT车次、始发站、终点FROM ticket WHERE票价>100C)SELECT车次、始发站、终点FROM ticket WHERE票价<100D)SELECT*FROM ticket WHERE票价>100
参考答案:
在表ticket中查询所有票价小于100元的车次、始发站和终点信息的命令是A)SELECT *FROM ticket WHERE票价<100B)SELECT车次、始发站、终点FROM ticket WHERE票价>100C)SELECT车次、始发站、终点FROM ticket WHERE票价<100D)SELECT*FROM ticket WHERE票价>100