Question 207739 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – what query to write that there are only "three"?

Table

a b
aa one
aa one
bb two
bb two
cc three

select distinct

a b
aa one
bb two
cc three

What query to write that there are only "three"?

Tags:

2

Answers


  1. 0

    Does the following provide the expected result?

    select a, b
from t
group by a, b
having count(*) = 1;
    Login or Signup to reply.
  2. 0 
    SELECT
   DISTINCT a, b
FROM
   table;

    I think this will result in what you need, yet the question is unclear. If this query does not solve your issue please clarify more what you need.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search