POWER IN SQL exponents

using the POWER function for exponentiation

SELECT *
FROM your_table
WHERE weight / POWER(height, 2) >= 30;

MySQL

SELECT *
FROM your_table
WHERE weight / POW(height, 2) >= 30;


PostgreSQL

SELECT *
FROM your_table
WHERE weight / (height ^ 2) >= 30;

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top