Posts by João Marques • 105 points
4 posts
-
3
votes1
answer222
viewsQ: Page Controller Pattern vs Front Controller
What is Page Controller? What is Front Controller? From what I read, page controller means a controller that is embedded in the html/jsf page facelet. However in the Front Controller the controller…
-
5
votes1
answer259
viewsQ: Why not iterate a hashmap?
I was doing a project and one of my colleagues mentioned that iterate hashmaps is something to avoid and instead of using hashmap should wear Linked lists. However I think the versatility of the…
-
0
votes1
answer55
viewsA: Is it possible to "Group by" by column content?
Using the "start-of-group" method it is possible to make a kind of iterator. select from ( select tbl.*, count(case when analysis = 0 then 1 end) over (order by year, mes, dia) as cnt from tbl )…
-
2
votes1
answer55
viewsQ: Is it possible to "Group by" by column content?
I was wondering if it was possible to use GROUP BY based on the date of a column, in this case the column ANALYSIS that creates groups whenever it finds 0, instead of the column. DIA MES YEAR TODAY…