I have a table with events describing user navigation through flows, with this general shape (disregard the timestamps, I smashed some keys): After the option_a event, users can go back and choose another option: Users can also go through a flow multiple times: I want to produce a table where each row represe…
Tag: sql
Conditional update with jsonb_set()
I have a table in a Postgres 11.3 database with a jsonb column. Trying to update all objects inside a nested array name “iProps”. If the path {iProps -> value -> rules -> ao -> sc} is an object, then the path should be updated from an object to a string with the value {iProps -> val…
Pick the max value of id from multiple tables
I have 3 tables. Each of them have id column as PRIMARY. There is no relation between tables. I want to make a query which gives me the max id of every table. What I have tried was this: But I get NULL, NULL, NULL. It is possible to done that? If yes, how? Answer MySQL syntax supports placing subqueries
tsql – pivot sum of employee
I have here a sample table data which i want to use pivot and make my DedCode data into column. the AMount example is already computed to its total but how can i count the number of employee if it is same with branch,deptcode and emptype. my sample table data. expected output: Answer You can use conditional a…
MS SQL identify duplicate rows based on log time
I have a fairly simple database table that logs every time a tray passes over an RFID reader. What sometimes happens is the data is being sent twice, so I have been asked if I can find out how often this happens. Rather than spending the next few days going through every record in the log table, I presume the…
Is there a way to create an ‘indicator’ in an SQL(DB2) select query to indicate when a column is filled?
This title is vague as hell and doesn’t completely cover the problem, but I don’t know how else to word it. Basically, I have the following situation: I have two tables: Table 1: COMPANY. shows company parent-child structure company parent-company A NULL B A C A D A E B Table 2: ACCOUNTS. accounts…
MySQL: Return a row if all joint table row have the value true
I’ve two tables as following. The relationship is What I want is to return for example for table A the record with id 1 which has a relationship with table B where all the values on table B column Delivered as true. Answer You can use group by and having: This doesn’t use table a. If you want all …
Variable length substring between two characters
Data looks like this: I want it to look like this: It’s pretty simple to get rid of one or the other. This: Gives me this: Initiative: Credible Sources Initiative: Just in Time Initiative: Database Normalization And this: Gives me this: Having a hard time figuring out how to combine the two. Answer How …
How to fill a SQL column with data (calculated) from another table
I have a question and don’t know how to approach the problem exactly. I have two tables as following: “Reference” in the “Client” table is defined as foreign key. Is it possible to fill the column “count” in the table “Tour” with an automated formula where…
Oracle sql | Share generated by default on null as identity
Is it possible to share the same “pool” for ids when using following syntax? When both attribute have the same name? The only possibility I came up was to start both at different values. Like Test on 1000 and test 2 on 2000 but this is not a long term solution. I’m looking to a solution wher…