EZ Study

Actuarial Biology Chemistry Economics Calculators Confucius Engineer

Formatting SQL Statement to look nice
Tricky tips to use group statment in SQL query within R

Some highly-recommended data visulization books

Formatting SQL Statement

SQL statement is so useful that not only analysts are necessarily to get familiar with, also many IT stuff or database adminstrators are using that quite often. The question is, sometime you get a very long SQL query, and it seems not that readable; Just like the following SQL query, it's really not that clear at the first glance of it.

The good news is that, we have some good tools to format the SQL query, so it's much easy to understand. One of the popular useful SQL formatting websites that LDD(Little Dumb Doctor) highly recommended is: www.poorsql.com. Also many
are using this one: http://www.dpriver.com/pp/sqlformat.htm.

Some highly-recommended R Tutorial books

Related links:
Continue to Regression Analysis in R   SAS Interview   Analytics Home

Back to Use SQL statement in R via package sqldf library   Statistics Home