Is it possible to order by a substring in a returned field?I've got a query which returns at most probably around 10 or so rows of 1 column. However the way this data is formated, it'd be convient ...

So, let’s celebrate SQL turning 50, and consider how we can continue to develop and use it in the future. Charly Batista is PostgreSQL technical lead at Percona .

If your business uses relational databases to store data, you may have used a SQL SELECT clause to create new tables from query results. This method won't work in SQL Server, but Microsoft's Trans ...