DB Manager has a SQL window that allows SQL queries to be executed against the database. This section will explain how to use the SQL window to query a table and create a spatial view in SpatiaLite.
Tip
Different databases support different SQL commands. SQLite supports much of, but not all, the standard SQL. For a complete listing of supported SQL operations, visit http://www.sqlite.org/sessions/lang.html.
To create a SQL query, perform the following steps:
In the Tree panel, navigate to and select the database on which you wish to perform a SQL query.
Navigate to Database | SQL window, or press F2 on your keyboard, to open the SQL window.
Enter a SQL query in the textbox at the top. Click on the Execute button or F5 on your keyboard to execute the SQL query against the database. The results of the query will be displayed in the results box at the bottom, and the number of affected rows and...