SQL Query With Between ,AND & OR in Where Clauses Not Given Correct Answers

Question

SELECT * 
FROM vtiger_crmentity 
where createdtime BETWEEN '2019-06-11 14:07:47' AND '2019-06-11 14:08:47' 
   OR modifiedtime BETWEEN '2019-06-11 14:07:47' AND '2019-06-11 14:08:47' 
  AND smownerid = '1' 
  AND setype = 'Potentials' 
  AND deleted = '0'`

But Not Give Me a Correct answer as i want, Suggest to Improve. response from Database with Query. https://prnt.sc/o0hhq9

Check precedence od operators https://dev.mysql.com/doc/refman/8.0/en/operator-precedence.html — PeliCan, Jun 11 '19 at 14:29

score 3 · Answer 1 · answered Jun 11 '19 at 14:31

You need parentheses for the OR condition.

SELECT * 
FROM vtiger_crmentity 
where (createdtime BETWEEN '2019-06-11 14:07:47' AND '2019-06-11 14:08:47' 
   OR modifiedtime BETWEEN '2019-06-11 14:07:47' AND '2019-06-11 14:08:47')
  AND smownerid = '1' 
  AND setype = 'Potentials' 
  AND deleted = '0'`

score 0 · Answer 2 · edited Jun 11 '19 at 16:34

0

Try using parenthesis () to segregate OR logic; the updated code can look like

SELECT *
FROM vtiger_crmentity
WHERE 
    (
        createdtime BETWEEN '2019-06-11 14:07:47' AND '2019-06-11 14:08:47'
        OR
        modifiedtime BETWEEN '2019-06-11 14:07:47' AND '2019-06-11 14:08:47'
    ) 
    AND smownerid = '1' 
    AND setype = 'Potentials' 
    AND deleted = '0'
;

edited Jun 11 '19 at 16:34

Mr Griever

4,014
3
23
41

answered Jun 11 '19 at 14:39

Dhanushka sasanka

518
3
18

1

`()` parenthesis. `[]` brackets – Juan Carlos Oropeza Jun 11 '19 at 15:06
Update your answer with correct details. replace the bracket as parenthesis. @Dhanushkasasanka – Dileepa Nipun Salinda Jun 11 '19 at 16:10
Thank You .After Read One articles on w3resource.com . I solved this problems. – Praveen Patel Jun 12 '19 at 14:15

SQL Query With Between ,AND & OR in Where Clauses Not Given Correct Answers

2 Answers2