Tuesday, May 30, 2017

use > and < instead of between

Example

SELECT title_id, ytd_sales
FROM titles
WHERE  ytd_sales > 4095 AND ytd_sales < 12000

No comments:

Post a Comment