SQLite Tag Archives

4

Query Results Using Boolean Logic

Old Fashioned Computer

In today’s lesson you’re going to learn how to query results using the WHERE clause. The objectives of today’s lesson are to: Learn to use more than one compare condition at a time using Boolean logic Comprehensive example with Select, Where, and Order By Using Multiple Conditions to Query Results In previous lesson’s we learned how the […]

Continue reading

How to Filter Query Results

Where Clause

In today’s lesson you’re going to learn how filter the results returned from your queries using the WHERE clause.  This clause is important as only those records matching the where clause’s conditions are returned in the query results. The objectives of today’s lesson are to: Learn about various condition types, such as Equality, Range, and […]

Continue reading
3

How to sort results using SQLite

Order

In this lesson you are going to explore how to sort your query results by using SQL’s ORDER BY statement.  Using this phrase allows us to sort our result in ascending or descending order.  In addition you can limit your query to a specified number of results. The lesson’s objectives are to: learn how to […]

Continue reading
>