I have a query which will sum up some fields of a table based on specified date range provided by the user.
My query is as follows:
Select sum(field1),sum(field2) from table1
where (date1 between fromdate and todate) or (date2 between fromdate and todate).
Since I have used or Keyword, if...