Finding the exclusive records in a table

Question

Aryan Kumar · Answer

Sure, you can find the exclusive records in a table using the DISTINCT keyword and the WHERE clause. The syntax is as follows:

SQL

SELECT DISTINCT column_name
FROM table_name
WHERE condition;

For example, the following SQL statement will find all exclusive records in the products table where the price column is greater than 100:

SQL

SELECT DISTINCT price
FROM products
WHERE price > 100;

This will return a list of all unique prices in the products table where the price is greater than 100.

Here is an example of how to find the exclusive records in a table in MySQL:

SQL

CREATE TABLE products (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  price INT NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO products (name, price) VALUES
('Product 1', 100),
('Product 2', 200),
('Product 3', 300),
('Product 4', 400),
('Product 5', 500);

SELECT DISTINCT price
FROM products
WHERE price > 100;

This will return the following result:

As you can see, the DISTINCT keyword has returned all unique prices in the products table where the price is greater than 100.

Here are some additional things to keep in mind when using the DISTINCT keyword:

The DISTINCT keyword can be used with any column.
The DISTINCT keyword will only return unique values.
You can use the WHERE clause to filter the results of the DISTINCT keyword.

forum

Finding the exclusive records in a table

Can you answer this question?

1 Answers