--- It aims to support SQL users to smartly retrieve data to support data professionals. --- Context: Databases have the data stored in an organized manner. However, we may come across situations ...

This repo is about how to sort semantic versions in SQL. By Semantic Versioning 2.0.0 format X.Y.Z Semantic Versioning 2.0.0: V1.10.1 or V1.2.0. Usual SemVer sorting for module, versions in ...

Is it possible to order by a substring in a returned field?<BR>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 ...

I'm having to hack a report together to pull data from another field in the same table. The row selection is going to be based on various elements in the above 'foreignkey' field - elements 1, 2, 4 & ...