用于限定查询行必须满足的查询条件所用关键字是
A: having
B: where
C: order by
D: group by
A: having
B: where
C: order by
D: group by
举一反三
- 在SQL查询语句中以下正确的子句顺序是? A: WHERE --- GROUP BY --- HAVING --- ORDER BY B: GROUP BY --- HAVING --- ORDER BY --- WHERE C: WHERE --- HAVING --- GROUP BY --- ORDER BY D: GROUP BY --- ORDER BY --- HAVING --- WHERE
- SELECT语句中,用于将查询结果进行排序的关键字是 A: HAVING B: GROUP BY C: WHERE D: ORDER BY
- 利用GROUP BY进行分组查询时,用于筛选满足条件的组,则应使用( )短语。 A: ORDER BY B: HAVING C: DISTINCT D: WHERE
- ________子句用于对查询结果进行分组。 A: ORDER BY B: GROUP BY C: HAVING D: WHERE
- 在SQL查询语句中,指出是有条件分组查询的两个子句是( )。 A: Order By和Having B: Order By和Where C: Group By和Where D: Group By和Having