Posts by lorDrakkar • 11 points

• 0

  votes

  3

  answers

  37

  views

  A: Select To view two-year billing sum

  I tried anyway and it won’t "SELECT (SELECT CAST(SUM(VLRBRU) AS VARCHAR(20)) FROM E140IPV WHERE CODEMP=1 AND CODFIL=1 AND datger BETWEEN TO_DATE ('2018/01/01', 'yyyy/mm/dd') AND TO_DATE…

  oracle

  answered 5 years, 1 month ago lorDrakkar 11

• 1

  votes

  3

  answers

  37

  views

  Q: Select To view two-year billing sum

  Good afternoon, I’d like to see the billing sum of two different dates(2018 x 2019, but I’m having trouble with the subselect "Details: "ODBC: ERROR [HY000] [Oracle][ODBC][Ora]ORA-00907: right…

  oracle

  asked 5 years, 1 month ago lorDrakkar 11