Common SQL queries

Simple query over one table

How to build a simple query with 1-2 conditions over one table (entity)

Query with table joins

An example of query which require to define a table join(s) in case of using SQL. It's much more simple with EasyQuery.

Query with OR operators

In this article, you will learn how to build queries that contain both with AND and OR operators.

Aggregate data

From this article you will see how to aggregate (count, sum, etc.) data in your queries.

Query with a subquery

How to build queries with subqueries using EasyQuery.