Question : I understand the distinction between: Scalar functions Set-Returning-Functions (SRF)s Internal functions Window functions Aggregate functions of all sorts […]
What does FHQT or FQA mean?
Question : I was reading this post by Andres Pascal, and I came accross a few new acronyms, As I […]
What is meant by “Stand-Alone Instance of SQL Server”
Question : I am cloning a server to perform an in-place upgrade and I will have to change the name […]
What is Sql Server Clustered Index in Oracle terminology
Question : A clustered index in sql server like a dictionary or telephone directory. A,B,C,D it goes on. If you […]
Multiple relationships between the same entities
Question : Is there a name for the case when two entities can have multiple relationships between themselves? Answer : […]
What is a “PARTITIONED OUTER JOIN”?
Question : This just came up in a question on Reddit, and I’m wondering What is a PARTITIONED OUTER JOIN […]
What does “ISO standard equivalent” actually mean?
Question : I’m reading about comparison operators. In the documentation, Comparison Operators Modified by ANY, SOME, or ALL it says […]
What is MySQL’s “Implicit Default Value” and how does it work with “strict mode”?
Question : From this question comments, In the documentation (dev.mysql.com/doc/refman/5.7/en/insert.html), inserting with INSERT INTO tbl_name () VALUES(); is mentioned. It […]
What does MBRContains and MBRWithin test? What does “contains” and “within” mean?
Question : MBRContains(g1, g2) is defined as, Returns 1 or 0 to indicate whether the minimum bounding rectangle of g1 […]
What is a “clob” or Character Large Object?
Question : I see in this post on listagg — Rows to Delimited Strings talking about SQL’s LISTAGG() clause ON […]