Which SQL Statement Is Used To Return Only Different Value

A) SELECT UNIQUE

B) SELECT INDENTITY

C) SELECT DIFFERENT

D) SELECT DISTINCT

Which SQL Statement Is Used To Return Only Different Value

Ans. The Correct Answer is Option D) Select Distinct.

To retrieve distinct or unique values from a database table in SQL, you can use the DISTINCT keyword in conjunction with the SELECT statement. Here’s the SQL statement:

SELECT DISTINCT column1, column2, ...
FROM table_name;

In this statement:

• SELECT specifies the columns you want to retrieve.
• DISTINCT ensures that only unique values are returned for those columns.
• column1, column2, etc., represent the names of the columns from which you want to retrieve distinct values.
• table_name is the name of the table from which you want to retrieve the data.

For example, if you have a table named “customers” and you want to retrieve a list of unique customer names, you can use the following SQL statement:

SELECT DISTINCT customer_name
FROM customers;

This query will return a list of distinct customer names from the “customers” table.