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 three 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!
Return the 3 most recent sales and then return the 3 oldest sales in the Purchase table.
Normally you can run multiple SELECT statements but SQL Fiddle is limited to one at a time only.
For the first part of the exercise you could avoid using ORDER BY, but for this part you will need to.
Using an ORDER BY clause is the only way to guarantee the order of the data returned.
Check out the answer here.
|Parts of this blog|
25 Aytoun Street