SQL and QUERY
Execution Order 1. FROM 2. ON 3. WHERE 4. GROUP BY 5. HAVING 6. SELECT 7. QUALIFY 8. ORDER BY ===================================================================== 🔹 BETWEEN Clause with String in Teradata Yes ✅ — BETWEEN works with strings in Teradata. But important point: 👉 It works based on lexicographical (dictionary) order , NOT numeric order. ✅ Basic Syntax column_name BETWEEN 'start_value' AND 'end_value' It is equivalent to: column_name >= 'start_value' AND column_name <= 'end_value' 🔹 Example 1 – Simple String Range SELECT name FROM employee WHERE name BETWEEN 'A' AND 'M' ; What it does: Returns all names starting from: A B C … M Because alphabetically: 'A' < 'B' < 'C' < ... < 'M' 🔹 Example 2 – Full Word Comparison WHERE name BETWEEN 'John' AND 'Mary' ; This includes: John Johnny Jordan ... Mary But NOT: Adam (comes befo...