search

kevinrae / mosskey

Multiple entry key for North American Mosses
0 stars 0 forks source link

Modifying SELECT command #32

Open stephenprae opened 6 years ago

stephenprae commented 6 years ago

INSERT INTO Taxa or KeyCharacter adds new character or taxon to end of current table, not into alphabetical sequence. Is there a means of inserting a way to insert a taxon or a character into a specofied place in the table. The reason is that SELECT returns the taxa or characters in the same sequence as they occur in the table. Can the SELECT command statement include a filter that sorts the entries alphabetically?

kevinrae commented 6 years ago

You can sort your results using the ORDER BY clause in your sql. https://www.w3schools.com/sql/sql_orderby.asp