Select ________ dept_namefrom college;Here which of the following displays the unique values of the column ? AllFromDistinctNameReview AnswerNext

To display the unique values of a column in SQL, you would use the DISTINCT keyword in your query. The correct choice from your options for the blank in the query you provided would be:

SELECT DISTINCT dept_name FROM college;

Explanation:

1. SELECT Statement: This is used to specify the column(s) you want to retrieve from the database.
2. DISTINCT Keyword: This keyword eliminates duplicate entries in the result set, giving you only unique values.
3. dept_name: This specifies the column from which you want to retrieve unique values.
4. FROM college: This specifies the table from where you are retrieving the data.

Thus, choosing DISTINCT ensures that only unique department names are returned when you run this query against the college table.