I am very new to using SQL. I am trying to extract data from the Micros 3700 database and am doing this successfully on interactive SQL. However, I am struggling to further specify the date. I want to have the latest day figures only. Preferably the same day.
I am using the following
to extract from the database. Is there a way to state which day I want displayed? Preferably the latest date.