Posts by Alan Darold • 33 points

• 1

  votes

  2

  answers

  242

  views

  Q: How to add several decodes in the same line?

  I need to group the fields of the Code in the same line some hint follows SQL SELECT DISTINCT iTG.GUI_NUMERO " NUMERO GUIA ", DECODE(itg.pro_tipo_procedimento,'MAT',…

  oracle

  asked 8 years, 2 months ago Alan Darold 33

• 0

  votes

  0

  answers

  88

  views

  Q: List only the largest age group?

  I am trying to do an age comparison to list only the age corresponding to your age range. Ex: 20 years age range from 0 to 43. SELECT DISTINCT U.USS_CODIGO, t.con_codigo, t.CON_SEQUENCIA,…

  oracle pl-sql

  asked 8 years, 6 months ago Alan Darold 33

• 1

  votes

  2

  answers

  62

  views

  Q: last table record change using MAX function

  I’m trying to bring all the records of a table by taking the last change so I used the MAX() function but it’s not returning any results. These are my terms: SELECT DISTINCT U.USS_CODIGO,…

  oracle11g

  asked 8 years, 6 months ago Alan Darold 33