Currently learning Data Science, here is what I've learnt so far. Pt.2
This time I learned about queries for data retrieval, feel free to read my notes and make any comments on tips, corrections or suggestions. Thx! :) Rename columns (AS) SELECT column_name AS 'column_rename' FROM table_name ; SELECT DISTINCT column_name FROM table_name ; DISTINCT is used to return unique values in the output. It filters out all duplicate values in the specified column(s). SELECT…
We haven't written up this one. Dev.to has the full story — the link below goes straight to it.