3 ms·
SQL is fantastic for relational data - it maps pretty closely to relational algebra. About all I'd change is placing the column names after the table/object na
by JohnBooty 12y ago
SQL is fantastic for relational data - it maps pretty closely to relational algebra.
About all I'd change is placing the column names after the table/object names - "FROM table1 SELECT col1, col2" instead of "SELECT col1, col2 FROM table" because it makes code assist features easier. (Microsoft did this with LINQ)
- delian66 12y agoI guess the reasoning for the 'SELECT ... FROM' is that the FROM part is optional, for example you can do stuff like 'SELECT 40+2 AS the_answer' .