[SQL Tip] Wrong output if you treat number as string in SQL
Free SQL Pattern Training: https://etlsql.kartra.com/page/sps-fr...
Do you understand SQL but still cannot write SQL queries correctly ?
Are you afraid to switch jobs because of the SQL interview rounds or have you failed SQL Interview earlier ?
If you are someone who understands SQL and need more confidence to solve SQL queries correctly, I would like to share my recent online course especially created for you.
Check for more details: https://etlsql.kartra.com/page/sql-pa...
Do not use quotes around your number in SQL. In this simple example I have shared how treating numbers as string in SQL can result in wrong output.
![SQL Timestamp ETL timezone problems are a NIGHTMARE [ETL Scenario -4] #sql #etl](https://images.videosashka.com/watch/7OQGTmU-SHs)
![Aggregate Fact Tables in Data Warehouse - Concept you must know [ETL Scenario -5] #etl #sql #dwh](https://images.videosashka.com/watch/Sy4_pkUqGmE)
![ETL Script Types and Concepts: The Ultimate Guide [ETL Scenario -3] #etl #sql](https://images.videosashka.com/watch/Xol-A26o6MQ)
![Intra-day Job orchestration & SQL: A full tutorial with example [ETL Scenario -2] #etl](https://images.videosashka.com/watch/kbQceQLRRZI)
![Do NOT run DROP TABLE in PRODUCTION. Use 2 alternate solutions [ETL Scenario -1 ] #etl #sql](https://images.videosashka.com/watch/FrlhAScErV8)
![The Frightening Reality Of Missing Records In An ETL Scenario [ETL Scenario -6] #sql #etl](https://images.videosashka.com/watch/w6SRJI0KZ6Q)
