James Wang Blog

A list of SQL best practices

Here are some SQL programming guidelines and best practices we collected, keeping quality, performance and maintainability in mind. This list is not complete at this moment, and will be constantly updated. Read more →

Tidy sql posted on your blog

As a sql developer, DBA. we often post sql code on our blog. Take this sql for example, select pub_name, count(qty) as orders, sum(qty) as total from sales inner join titles on (sales. Read more →