Sorting, filtering and export
A result arrives a page at a time. What you sort, filter and find in the grid works on the rows already loaded; what you ask of the server works on the whole table.
Sorting
Click a column’s header to order the loaded rows by it: ascending, then descending, then the order the server sent. Numbers sort as numbers, and NULLs come last going up. Rows you added stay at the bottom.
Filtering
Show a filter box over every column, on the rail beside the grid, puts a box over each column. Whatever you type there keeps the loaded rows that hold it, ignoring case, every box at once.
For the whole table rather than the rows on screen, Filter and order the whole table opens two fields, WHERE and ORDER BY, applied with Enter: the statement is run again with them. It works on a statement that reads one table, and its ORDER BY only where the statement does not already order itself. Build a condition writes the WHERE for you from rows of a column, a condition such as is, is more than, matches or is NULL, and a value, joined by and or or.
Finding
Find in result, in the Edit menu, the palette or the rail, searches the loaded rows, ignoring case. The cells that match are lit, Next and Previous step through them, and the count says where you are. It has no key until you give it one: Ctrl+F finds in the console.
Exporting
Export the result, Ctrl+Shift+E, writes a file in one of seven formats: CSV, JSON, INSERT script, Markdown table, HTML page, XML and Excel workbook. The statement is run again for it, with the WHERE and ORDER BY above, so the file holds every row and not only the page on screen.
=.Settings → Result keeps the format and the CSV choices you use most.
Copying
Select cells with Shift and the arrows, or Shift and a click, and Ctrl+C copies them as text: a tab between cells and a line between rows, without the header. A NULL is copied as Settings → Grid → Value for NULL says. Copy cell in the right-click menu copies one value.
Bars
Draw these rows as bars opens the Chart tab: the last numeric column measured against the first text column, for up to the first 200 rows of the page. A result with no numeric column has nothing to draw, and says so.