Vertica Quick Tip: Getting the Root of a Number

Posted April 18, 2018 by Soniya Shah, Information Developer

This blog post was authored by Jim Knicely. You can find the square root of a number with the |/ operator and the cube root of a number with the ||/ operator. Example: dbadmin=> SELECT |/25 square_root_of_25, dbadmin-> ||/27 cube_root_of_27; square_root_of_25 | cube_root_of_27 -------------------+----------------- 5 | 3 (1 row) Have Fun!