Category: sql
SQL Left Outer Join can be illustrated by the following: where the query will take everything from left table and those fields from the right table. Let’s take a …
Given a Relational Table stroing the nodes in a tree-like data structure, like this: +----+------+ | id | p_id | +----+------+ | 1 | null | | 2 | …
Motivation How many of you sometimes want to know how much you have been paid by writing good contents? Especially for those regular writers or even full time steemians, …
SteemSQL is a great service (MSSQL) developed and maintained by @arcange despite the fact that it moved to a monthly subscription model. The most important thing for a BlockChain …
I spent around 800 SBD (7000 USD) in buying votes. The following queries the table TxTransfers thanks to @arcange’s STEEMSQL. select "from", "to", "memo", (amount) from TxTransfers (NOLOCK) where …