SQL SELECT | Basic SQL - Mode
mode.com/sql-tutorial/sql-select-statement/
2 Users
0 Comments
6 Highlights
0 Notes
Tags
Top Highlights
SELECT indicates which columns you'd like to view, and FROM identifies the table that they live in.
SELECT indicates which columns you'd like to view, and FROM identifies the table that they live in.
Capitalizing commands is simply a convention that makes queries easier to read. Similarly, SQL treats one space, multiple spaces, or a line break as being the same thing.
Most people avoid putting spaces in column names because it's annoying to deal with spaces in SQL—if you want to have spaces in column names, you need to always refer to those columns in double quotes.
hout the double quotes, that query would read 'West' and 'Region' as separate objects and would return an error
that the results will only return capital letters if you put column names in double quotes
Ready to highlight and find good content?
Glasp is a social web highlighter that people can highlight and organize quotes and thoughts from the web, and access other like-minded people’s learning.