Tag: sql filtering

You should use a filter in a query so that only the records you want to see are returned.

how to use case statements in SQL

2021-02-06T13:55:58+00:002024-06-04T19:29:08+00:00 admin

In recent posts on SQL here on this website, we have covered off a number of ways to extract your data from wildcards to filters. Here we are going to build on that learning, but bring in a new dimension in the use of case statements. These are very handy to use when you may…

SQL, SQLite

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