Limit works while a where between clause doesn't?
I made my own subset B:
JOIN dept_emp de on e.emp_no = de.emp_no
WHERE e.emp_no between '110021' and '10040'
GROUP BY e.emp_no
ORDER BY e.emp_no
) AS B
23 records.
Next I tried:
JOIN dept_emp de on e.emp_no = de.emp_no
WHERE e.emp_no >'110021' and emp_ no < '10040'
GROUP BY e.emp_no
ORDER BY e.emp_no
) AS B
23 records.
I don't understand why a limit 20 brings back the correct number of rows while both where clauses fail.
Hi Crystal!
Thanks for reaching out.
Could you please provide your question with more explanation? This can help us assist you better. Thank you.
Looking forward to your answer.
Best,
Tsvetelin
Hi Crystal!
On the Where clause in your queries, it should be 10021 not 110021. I hope it helps.
Hi Crystal and Thai!
Thanks for reaching out.
@: Thai
Thanks for sharing information with the Community!
@: Crystal
As Thai said you should change the range from 10021 to 10040.
Hope this helps.
Best,
Tsvetelin