Question

Which of the following keywords will you use in the following query to display all the values of the column dept_name ?
SELECT ________dept_name FROM Company ;
a. ALL
b.FROM
c.DISTINCT
d.NAME​

Answer 1

Answer:

ALL

Explanation:

ALL is used to select all records of a SELECT STATEMENT. It compares a value to every value in a list or results from a query. The ALL must be preceded by the comparison operators and evaluates to TRUE if the query returns no rows. For example, ALL means greater than every value, means greater than the maximum value. Suppose ALL (1, 2, 3) means greater than 3.

Syntax:

SELECT [column_name... | expression1 ]

FROM [table_name]

WHERE expression2 comparison_operator {ALL | ANY | SOME} ( subquery )

Answer 2

Answer:

a. ALL

Select ALL dept_name From company