Apache Derby: Clause Cheat Sheet

Where Clause

ij> SELECT * from table_name WHERE condition;
or,
ij> DELETE from table_name WHERE condition;
or,
ij> UPDATE table_name SET column_name = value WHERE condition;

GROUP BY Clause

ij>SELECT column1, column2, . . . table_name GROUP BY column1, column2, . . .;

ORDER BY Clause

SELECT * FROM table_name ORDER BY column_name ASC|DESC.

Having Clause

ij> SELECT column1, column2 . . . from table_name GROUP BY column having