Filter Query Results

The filter query results option allows users to filter query results using various options depending on whether the filter column selected is character or numeric data. Numeric options include equals, not equals, less than, greater than, etc. Character options include is, is not, contains, contains not, in, and not in.

After executing a SQL query, RazorSQL adds a new query results tab containing the results of the query. On this tab are many options such as export, import, sort, search, and filter. If filter is selected, RazorSQL will apply the filter criteria to the query results, and only display rows that match the filter criteria. After executing a filter, the result set should be considered closed. To get back to the original results, the user would need to re-execute the query.

The filter query results option is available via the query results toolbar, the right-click menu of the query results tab, or via the Results menu.

Filter Query Results