When you "save" your query, you can re-run it at anytime, edit it (change the sort order, columns, etc.), rename it, etc.

You can run any query with a single click on the icon.

To edit a query, click the symbol next to the query you want to edit.

A query with a lock symbol () means the query has been password protected. You can run the query just like any other query, but in order to edit it, you must know the password assigned to the query when it was protected.

A query with a star symbol () means that it is a custom query and that you have to understand SQL in order to edit it. ClickQuery does not show the tables and columns in the query as it does for a non-custom query.