### Special variables
-| Expression | Description |
-| ---------- | ---------------------------- |
-| `$?` | Exit status of last task |
-| `$!` | PID of last background task |
-| `$$` | PID of shell |
-| `$0` | Filename of the shell script |
+| Expression | Description |
+| ---------- | -------------------------------------- |
+| `$?` | Exit status of last task |
+| `$!` | PID of last background task |
+| `$$` | PID of shell |
+| `$0` | Filename of the shell script |
+| `$_` | Last argrument of the previous command |
See [Special parameters](http://wiki.bash-hackers.org/syntax/shellvars#special_parameters_and_shell_variables).
{: .-setup}
```csv
-date , ? , desc , account , currency , amt , pending/cleared , ?
-"2013/09/02" , "" , "things" , "Assets:Cash" , "P" , "-2000" , "*" , ""
-"2013/09/02" , "" , "things" , "Liabilities:Card" , "P" , "-200" , "*" , ""
-"2013/09/02" , "" , "things" , "Expenses:Things" , "P" , "2200" , "*" , ""
-"2013/09/04" , "" , "stuff" , "Assets:Cash" , "P" , "-20" , "*" , ""
-"2013/09/04" , "" , "stuff" , "Expneses:Others" , "P" , "20" , "*" , ""
+date , code , desc , account , currency , amt , pending/cleared , notes
+"2013/09/02" , "" , "things" , "Assets:Cash" , "P" , "-2000" , "*" , ""
+"2013/09/02" , "" , "things" , "Liabilities:Card" , "P" , "-200" , "*" , ""
+"2013/09/02" , "" , "things" , "Expenses:Things" , "P" , "2200" , "*" , ""
+"2013/09/04" , "" , "stuff" , "Assets:Cash" , "P" , "-20" , "*" , ""
+"2013/09/04" , "" , "stuff" , "Expenses:Others" , "P" , "20" , "*" , ""
```
SELECT * FROM table1, table2;
SELECT field1, field2 FROM table1, table2;
SELECT ... FROM ... WHERE condition
-SELECT ... FROM ... WHERE condition GROUPBY field;
-SELECT ... FROM ... WHERE condition GROUPBY field HAVING condition2;
+SELECT ... FROM ... WHERE condition GROUP BY field;
+SELECT ... FROM ... WHERE condition GROUP BY field HAVING condition2;
SELECT ... FROM ... WHERE condition ORDER BY field1, field2;
SELECT ... FROM ... WHERE condition ORDER BY field1, field2 DESC;
SELECT ... FROM ... WHERE condition LIMIT 10;