Code: Select all
SELECT *
FROM (`employees`)
WHERE `position` = 1
OR `position` = 3
AND `status` = 1
ORDER BY `position` desc Is there anything wrong with the query that I am not seeing?
Moderator: General Moderators
Code: Select all
SELECT *
FROM (`employees`)
WHERE `position` = 1
OR `position` = 3
AND `status` = 1
ORDER BY `position` desc Code: Select all
SELECT
*
FROM
employees
WHERE
(position = 1 OR position = 3)
AND status = 1
ORDER BY
position desc