Tag: SQL where clause

You can use an SQL where clause to filter records in your query so that you only see the ones you want.

How to use wildcards in SQL

February 4, 2021May 23, 2021 admin No Comments

Following on from from our previous posts on SQL, this post will help to explain how to use wildcards in your query. What would you use a wild card in the first place? When a data analyst dealing with a large dataset, it is most likely that they will not know every piece of data….

SQL, SQLite, strings

select rows with a certain value using SQL

January 22, 2021February 9, 2021 admin No Comments

You have now started to understand your database structure and want to extract data from it. Data analytics projects can have lots of data, you need a way to get to what you need quickly and easily. The question now becomes how would you achieve this? The most easiest way is to add a where…

SQL, SQLite, Working with databases