The applause fades, the Q&A concludes, and your webinar session officially ends. For many, this marks the finish line. But for savvy marketers in 2025, the real work — and the greatest opportunity for conversion and revenue — has just begun. The post...
Question: I'm wondering if it's possible to create a custom SQL group by function. For example, I often need to find the most common value within a group. While I can achieve this using CTEs or subqueries, having a custom group by function like the e...
Question: I have a table books : Name of columnType idint (PK) nametext nb_pagesint And a table book_modifications : Name of columnType idint (PK) old_datajsonb new_datajsonb book_idint (FK) Now let's imagine I have a row in my...
Question: Currently, I having a query SELECT al.category, IFNULL(jt.name, 'Ungrouped Devices') AS device_group_name, IFNULL(jt.id, '00000000-0000-0000-0000-000000000000') AS device_group_id, jt.color_code AS color_code, COUNT(*) AS total FR...
Question: My table contains a value json-column: { "id":"string", "user":int, "history":{ "unixtimestamp":{ "progress":"string", "editorId":int }, "unixtimestamp":{ "progress":"s...
Question: To simulate a lock in mysql I can grab the row with the following: BEGIN; SELECT * FROM table WHERE id=1 FOR UPDATE; Now, if I try and update that row (from another connection) it will raise the following error after innodb_lock_wait_timeo...
Question: I'm using SQL Server and Management Studio. I was getting data conversion errors when performing a BULK INSERT into a table, that I could not resolve and switching to using a format file allowed data to be inserted, but the data inserted wa...
Question: I am trying to enable system versioning to an existing table like this ALTER TABLE [dbo].[User] ADD ValidFrom DATETIME2 GENERATED ALWAYS AS ROW START, ValidTo DATETIME2 GENERATED ALWAYS AS ROW END, PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo...
Question: This code: declare @x int = 1, @y int = @x; gives the error: Must declare the scalar variable "@x". I read through the Microsoft documentation for the DECLARE keyword along with some other sources, but none thoroughly explained this beha...
Question: I have two tables, one a parent of the other, let's call them CUST and CUST_ADDR. Each table is a history table, so each time a value in one of the data fields changes, another record is added with the new value and a date it was changed. S...
