Posts by WesleyCP • 1 point

• 0

  votes

  1

  answer

  241

  views

  A: 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…

  mysql sql script mysql-workbench

  answered 4 years, 3 months ago WesleyCP 1

• 0

  votes

  2

  answers

  159

  views

  A: 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…

  sql join

  answered 4 years, 3 months ago WesleyCP 1

• 0

  votes

  2

  answers

  59

  views

  A: 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…

  sql sql-server query

  answered 4 years, 3 months ago WesleyCP 1