I’m using SQL Server Management Studio 18 and I’ve got the following tables with the following columns: TableA TableB I want to do an INSERT SELECT into TableB, maybe something like the following: Basically, I just want to make an INSERT SELECT where I’m grabbing a column from another table …
Optimizing GROUP BY + COUNT DISTINCT on unnested jsonb column
I am trying to optimize a query in Postgres, without success. Here is my table: I have indexes on id and meta columns: There is 62k rows in this table. The request I’m trying to optimize is this one: In this query, meta is a dict like this one: I want to get the full list of key / value
SQL – Matching only the values in IN clause (not less or more)
I am having the following ManyToMany table TEAM_USERS with the below data: So, I want to get the TEAM_ID that is having only two user with the USER_ID IN (3, 4), in this case it’s team 11. But I am getting team 1, 11, and 12. And I want only team 11. I did the following code but I am
how to Join array with string in Snowflake
I have two tables: Books with column tag_ids (Array) Tags with column tag_id (Varchar) I have a visualisation tool that need to join these tables together. The only thing that I can control over is the join condition. the problem is that I can’t find a way to make this join work. this is what I tried: T…
Complex SQL query by pattern with timestamps
I have the following info in my SQLite database: I want to perform a query that returns the elements that compose an episode. An episode is a set of ordered registers that comply the following requirements: The first element is greater than zero. The previous element of the first one is zero. The last element…
Count distinct value of column regardless change in other columns
I have the following table: And I want to count distinct Whispers knowing that there is a change in client column, currently I’m using this: But I see that W1 and W2 are counted twice for each client but I need to consider them as one no matter the client is, so for the first time If I got iOS
Why is the current time constant when executing for every row (using a LATERAL JOIN)?
Why is it the case that I can see the same timestamp when wrapping a now() function within a lateral join. I formulated a code sample to illustrate by example: Results in the same timestamp, for example (trimmed): I would have expected that each row contains a new timestamp (in increasing order) as LATERAL is…
Filter country using a JOIN in BigQuery
In a scheduled query in BQ, I am trying to filter countries using an external Google Sheet (already made a table). The query already has a join from two other tables. I would like to enter a SELECT clause in the WHERE statement. I keep getting errors. Any tips as to where I am going wrong? Expected output wou…
Check datatype of column after applying function MySQL
I want to know datatype of column after using a function. After using timediff function what datatype is it? I’ve looked at the doc to search for output datatype of a function https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html but could not find, Also it would be inefficient to memoriz…
Sql Database design hierarchy
I have been tasked to create an app to track our contracts. I am planing to use Django and PostgreSQL. Our existing data is in Excel with 52 rows. I have found an hierarchy pattern in the file which contains as below Holding Office Registered Office Operating Office For example – Holding office (company…