How to select distinct multiple columns in MySQL and Oracle database?
(Also works with PostgreSQL)
-
How to Select Distinct Multiple Columns in MySQL and Oracle Database?
smallwei
7:53 pm on November 15, 2009 |
Answers: 1
Tags: database (51), mysql (35), oracle (136), postgresql
Rate Knowledge:
(1 votes)
Loading ...
Related Knowledge
Are There Any Difference Between SELECT UNIQUE and SELECT DISTINCT in Oracle?- How to select an Oracle database table from remote database that has CLOB field?
- Example on How to Update Field with Corelated Select Subquery in Oracle Database…
- How to Search (Find) and Replace String in MySQL or Oracle Database Using SQL?
- In SQL, how can you select and match more than one column in a sub-select?
smallwei 7:53 pm on November 15, 2009
Essentially there are two ways to do it:
1. Use SELECT DISTINCT
SELECT DISTINCT a,b,c FROM table2. Use GROUP BY
SELECT a,b,c FROM table GROUP BY a,b,c