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

2021-02-04T16:03:14+00:002024-06-04T19:29:09+00:00 admin

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

2021-01-22T16:56:50+00:002024-06-04T19:29:15+00:00 admin

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 easiest way is to add a where clause…

SQL, SQLite, Working with databases