Mastering SUBSTR and INSTR in SQL 🧙♂️📊 Stop struggling with messy text data. 🛑 If you work with databases, you know that raw data is rarely perfect. Cleaning names, extracting domains from emails, ...
🚀 Day 10 – SQL Single Row Functions Today I learned how to clean and transform data using functions --- 🔹 1. UPPER() 👉 Converts text to uppercase SELECT UPPER('sql'); Output: SQL --- 🔹 2. LOWER() ...
GET NEW CONNECTION SWITCH TO AUTOCOMMIT MODE SELECT substr(w.FIRST_NAME,1,3) FROM "Worker" "w" raw_sql('substr(w.FIRST_NAME,1,3)') ----- FIR FIR FIR FIR FIR ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results