postgresql

 https://www.geeksforgeeks.org/postgresql-begin/

SQL Select 语句完整的执行顺序

https://www.geeksforgeeks.org/postgresql-rollback/

postgresql-forward-fill-null-values-with-previous-not-null-value-in-group

https://dbfiddle.uk/mjQvoZuf

https://dbfiddle.uk/ToZ2AhaQ

postgresql-fill-null-values-in-timeserie-query-with-previous-value

forward-or-backward-filling-in-postgres

update-with-with-and-case-postgresql

https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-case/

https://www.postgresqltutorial.com/postgresql-window-function/

https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-update/

https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-drop-column/

https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-add-column/

https://www.postgresqltutorial.com/postgresql-tutorial/postgresql-double-precision-type/

using-window-function-to-carry-forward-first-non-null-value-in-a-partition

https://www.w3schools.com/sql/sql_wildcards.asp