Posts by Edival • 146 points

• 3

  votes

  2

  answers

  358

  views

  A: How can I select unique data in SQL?

  SELECT DISTINCT EX.GSM, EX.MOTIVO_ENVIO, EX.STATUS FROM EXPORT EX WHERE EX.STATUS = 'ANOMALIA TEMPORÁRIA' AND EXISTS ( SELECT TMP.GSM FROM EXPORT TMP WHERE TMP.GSM = EX.GSM GROUP BY TMP.GSM HAVING…

  sql postgresql select

  answered 5 years, 9 months ago Edival 146