Answers for "between clause in mysql"

SQL
0

mysql between

SELECT 
   orderNumber,
   requiredDate,
   status
FROM 
   orders
WHERE 
   requireddate BETWEEN 
     CAST('2003-01-01' AS DATE) AND 
     CAST('2003-01-31' AS DATE);
Code language: SQL (Structured Query Language) (sql)
Posted by: Guest on November-13-2021
0

use between operator in mysql

SELECT * FROM cars.customers
where creditLimit 
between 20000 and 500000;
Posted by: Guest on September-12-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language