by Federico Razzoli | Aug 15, 2024 | SQL Language
In SQL, everything is a table. Even the results of a query are a table. This means that you can select rows and columns from the results of another query. Sometimes this allows us to do things that would otherwise be impossible. For example, joining the results of an...
by Federico Razzoli | Jul 30, 2024 | SQL Language
SQL is the language of data. You write a query, a single sentence in a language that resembles English, and you obtain the data you need. It’s supported by the majority of databases, and the language is pretty standard. If you have a query that works on Oracle,...