Posts by Alan Darold • 33 points
3 posts
-
1
votes2
answers242
viewsQ: 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',…
oracleasked Alan Darold 33 -
0
votes0
answers88
viewsQ: 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,…
-
1
votes2
answers62
viewsQ: 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,…
oracle11gasked Alan Darold 33