Posts by Alex • 21 points

• 1

  votes

  2

  answers

  58

  views

  A: Bring records that is not in another table

  SELECT * FROM quiz a WHERE status = 'publicado' AND NOT EXISTS (SELECT 1 FROM quiz_resolvido b WHERE a.id_quiz = b.id_quiz AND b.id_usuario = 1)…

  mysql sql database

  answered 5 years, 7 months ago Alex 21

• 1

  votes

  1

  answer

  107

  views

  Q: How to select distinct from the Listagg function in the 12C database

  Is there any 12c bank function you can use on listagg and does not bring repeated results? SELECT SUM(quantidade) quantidade, LISTAGG (mib.segment1, ' - ') WITHIN GROUP (ORDER BY ROWNUM) item,…

  sql oracle oracle12c

  asked 5 years, 8 months ago Alex 21