Posts by WesleyCP • 1 point
3 posts
-
0
votes1
answer241
viewsA: How to make a total disjunction in EER diagram? (Mysql Worckbench)
Normalises the payment entity. Creates a single payment table with the required fields and also creates a Payment Type table. Then add a Fk to the pay table. This way you will only have two tables…
-
0
votes2
answers159
viewsA: Make Join in table that has two ID in the same column
I saw there that you are using Oracle... not PL/SQL manjo, but if it was in SQL Server I would do something like this: SELECT * FROM TECH_TABLE AS A CROSS APPLY (SELECT…
-
0
votes2
answers59
viewsA: Average between select results
SELECT DISTINCT OS.TAG AS OS, APLIC.TAG AS APLICACAO, AVG(CONVERT(DECIMAL(10,2), ROUND(DATEDIFF(SECOND, OS.MAQPAR, OS.MAQFUN)/3600.0, 2)) OVER(PARTITION BY OS.TAG,APLIC.TAG ) AS…