BEtween Operator in SQL

BETWEEN Operator Example The “Persons” table: Now we want to select the persons with a last name alphabetically between “Hansen” and “Pettersen” from the table above. We use the following SELECT statement: The result-set will look like this: P_Id LastName FirstName Address City1 Hansen Ola Timoteivn 10 Sandnes The BETWEEN operator is treated differently in … Read more