PrisonPants PrisonPants - 1 year ago 60
SQL Question

Total number of some rows of a special record

I wrote this:

SELECT * FROM `playerdetails` WHERE `power` + `violence` + `shooting` >= '50' LIMIT 1


I want the correct way.

Answer Source
SELECT * FROM `playerdetails` WHERE (`power` + `violence` + `shooting`) >= '50' LIMIT 1