Menu
I would like to select the rows that has the same values across column A and column B.
For example if my table is:
-----
A | B
-----
1 | 2
3 | 4
1 | 2
4 | 5
The output should be:
A B
1 2
SELECT DISTINCT A, B FROM table;SELECT DISTINCT (A, B) FROM table;SELECT A, B FROM table GROUP BY A, B;The question is similar to Selecting Distinct combinations., but the answer suggested there doesn't work.
754
To get the identical rows (based on two columns agent_code and ord_amount) once from the orders table, the following SQL statement can be used : SQL Code: SELECT DISTINCT agent_code,ord_amount FROM orders WHERE agent_code='A002';
How Can we use MySQL DISTINCT clause with WHERE and LIMIT clause? By using the WHERE clause with a DISTINCT clause in MySQL queries, we are putting a condition on the basis of which MySQL returns the unique rows of the result set.
MySQL DISTINCT clause is used to remove duplicate records from the table and fetch only the unique records. The DISTINCT clause is only used with the SELECT statement. Syntax: SELECT DISTINCT expressions.
You want only the rows which have duplicates. You can use the HAVING clause to filter "groupings" of data based on aggregation functions:
SELECT A,B
FROM tbl
GROUP BY A,B
HAVING COUNT(*) > 1
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
