Posts by Victor Andrade • 35 points
4 posts
-
0
votes1
answer122
viewsQ: HELP! How to perform Datediff with difference between columns and not current_date?
I’m in need of a simple, data difference (DIA) feedback on Firebird, but I’m not getting the feedback and try many ways ... the Command below works ... Datediff (day from Max (distinct TRAVEL.DATE)…
firebirdasked Victor Andrade 35 -
2
votes1
answer746
viewsQ: Rounding in SQL
I need to perform a rounding of a result. Oracle looks like this: SALDO_TONELADA = (A.PESO * 20,0); The value of the column A.PESO is of 24.432 and multiplied by 20 gives 488.640. My goal was to…
-
-1
votes1
answer81
viewsQ: COUNT + JOIN WITH DIFFICULTY IN RESULT
I need to get two results... I have a table with a total of 102 drivers and another table with the date he left to make deliveries and another with the arrival date... I need to know which drivers…
-
-2
votes1
answer65
viewsQ: 0097 - missing parentheses on the right. - Can help
I know you already have some negotiations here in the forum about this error 0097 - missing parentheses to the right.. This is my command, you can help me ? select distinct Coalesce(Sum(Case When…