562 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Practise SQL in your browser with SQL Fiddle
Part eleven of a sixteen-part series of blogs
Some of our poor delegates don't have the luxury of a home computer to install SQL on (even worse some have made bad life choices and picked a Mac). The good news is that you can still practise your SQL skills in your web browser, using the impressive SQL Fiddle site. Have no fear, SQL Fiddle is here, a browser based sandbox to bring you cheer!
Calculate the number of days which have elapsed between the date of each sales and today's date.
Remember the function to return today's date is GETDATE(). Your result will vary based on the date when you run your query!
Now filter this to only include events that happened within the last 6 months. Use DataAdd() with Between to achieve this.
For the data of 21st June 2021 this returns 20 rows (feel free to substitute GETDATE() with this date to test your query).
See the answer here.
|Parts of this blog|
25 Aytoun Street