Beginner needs help? I want to query my DB and return 3 columns with x,y,min where min column should be the minimum sqrt(x+y)? I want to be returned only the minimum value (only one row, like limit 1)!
Also I want that MIN column returned is > 0 ?
What is wrong with the following query?
select x,y,((SELECT min(sqrt(x+y))) from TABLE1) as MIN from TABLE1
Also I want that MIN column returned is > 0 ?
What is wrong with the following query?
select x,y,((SELECT min(sqrt(x+y))) from TABLE1) as MIN from TABLE1