相关考题
-
单项选择题
查询book表中book_name字段和book_price字段的信息,查询语句是()
A.select book_name,book_price from book ;
B.select *from book;
C.select book from book_name,book_price ;
D.select *from book book_name,book_price; -
单项选择题
查询xs数据表中的所有数据,并按学号降序排列,语法格式是()
A.select *from xs group by 学号desc;
B.select *from xs order by 学号asc
C.select *from xs order by 学号desc;
D.select *from xs 学号order by; -
单项选择题
在SELECT语句的SELECT子句中使用关键字()可以过滤重复行。
A.UNION
B.DISTINCT
C.ALL
D.TOP