LIMIT {Ans: [offset,] number of row; maximum # of records retrieved}GROUP BY {Ans: grouping values; results by one or more columns}+ {Ans: Addition}describe TABLESNAME; {Ans: it displays information about each of the table's columns.}show databases; {Ans: a list of databases}List multiple columns {Ans: SELECT DISTICT}