Question

................ keyword is used in SELECT statement along with column name to display duplicate values once in the result of an SQL query.

Hint:

Use DISTINCT to retrieve unique values in SQL query results.

Answer 1

In SQL, the DISTINCT keyword is used in a SELECT statement to remove duplicate records from the result set.
When selecting data from a column that may contain repeated values, DISTINCT ensures that only one occurrence of each value appears in the output.
For example, the query SELECT DISTINCT country FROM users; will return a list of unique countries from the users table.
DISTINCT applies to the entire row if multiple columns are specified.
This is useful in reporting and filtering scenarios where duplicates are not desired.