一、原题 Where can subqueries be used? (Choose all that apply.) A. field names in the SELECT statement. B. the FROM clause in the SELECT statement. C. the HAVING clause in the SELECT statement. D. the GROUP BY clause in the SELECT statement. E. the WHERE…
一、原题 View the Exhibit and examine the structure of the PROMOTIONS table. Examine the following two SQL statements: Statement 1 SQL>SELECT promo_category,SUM(promo_cost) FROM promotions WHERE promo_end_date-promo_begin…
排序 order by 列名 asc(默认) desc(降序)
查询所有学生记录 按年龄升序排列
select * from student order by age;
或者
select * from student order by age ASC;查询所有学生记录,按年级降序排序
select * from student order by age DESC;查询所有学生,按班级数字降序排序…
一、原题 Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?(Choose all that apply.) A. The HAVING clause can be used with aggregate functions in subqueries. B. The WHERE clause can be used to exclude rows after dividi…