# Build a SELECT Query

Designer allows you to build a query for both SQLite (the default database) and SQL Server databases. However, the syntax for these databases is different.

The table below shows the format for constructing SELECT queries (only SELECT and FROM are operators that are required).

SQLite | SQL Server
--- | ---
SELECT expressions | SELECT[TOP top_value] expressions Note: SQL Server uses the optional operator, TOP, immediately after the SELECT operator, not at the end, like SQLite.
FROM tables | FROM tables
WHERE conditions | WHERE conditions
ORDER BY expression [ASC | DESC ] | ORDER BY expression [ASC | DESC ]
LIMIT number_rows OFFSET offset_value |