Posts by Daniela Petruzalek • 121 points

• 2

  votes

  2

  answers

  614

  views

  A: How to make a Select to not show reset result?

  You can use the HAVING clause to filter aggregate values: SELECT COUNT(DISTINCT ROMANEIO) ROMANEIO FROM PCN_ROMANEIO_DISTR_ITEM WHERE USUARIO = 'junior' HAVING COUNT(DISTINCT ROMANEIO) > 0 UNION…

  sql oracle

  answered 8 years ago Daniela Petruzalek 121