-- Variance SELECT variance(col_name) FROM table_name; -- Population variace SELECT var_pop(col_name) FROM table_name; -- Sample variace SELECT var_samp(col_name) FROM table_name; -- Standard deviation SELECT stddev(col_name) FROM table_name; -- population standard deviation SELECT stddev_pop(col_name) FROM table_name; -- sample standard deviation SELECT stddev_samp(col_name) FROM table_name; -- truncate SELECT trunc(42.1256, 2); -- (42.12) -- series SELECT generate_series(1, 10, 2); -- (1,3 ... , 9) -- correlation SELECT corr(assets, equity) FROM fortune500; -- continuous percentile SELECT percentile_cont(0.5) WITHIN GROUP (ORDER BY col_name) FROM table_name; -- discrete percentile SELECT percentile_disc(0.5) WITHIN GROUP (ORDER BY col_name) FROM table_name; -- NOTE: DO NOT FORGET SUM, MIN MAX, AVG, COUNT etc