In order to get cube of column in postgresql we use POWER() function. POWER() function in posgresql gets the cube of the column. Let’s see how to
- Get cube value in postgresql
- Create the column which extracts the cube from another column
With an example for both
Get Cube in Postgresql:
POWER() function in posgresql gets the cube value
SELECT POWER(3,3) AS "Cube";
So the cube will be
Get Cube of column in Postgresql table:
We use table student_details
SELECT *,POWER(gradscore,3) AS cube_gradscore FROM student_detail;
We have created a column and stored cube of gradscore column.
So the resultant table will be
