Differences

This shows you the differences between two versions of the page.

--- dbquery:test2 [2025/08/27 09:12] – created Richard White
+++ dbquery:test2 [2025/08/27 12:03] (current) – Richard White
@@ Line 1: / Line 1: @@
- ====== Test2 query ======
+ ====== Test2 table query ======
-  <code sql>
+<code sql>
-  SELECT * FROM species;
+SELECT common_name AS "Common name", scientific_name AS "Scientific name", date, location, note, id FROM species ORDER BY scientific_name;
-  </code>
+</code>