Tag: sql

Indexing (x 4 OR y 5)

I am searching for an index to make the following quick: The query is a delete and reads: so it deletes all rows that do not match a few hundred criteria on t1 and t2. explain gives a sequential scan and rearranges the query: Can I create an index that will avoid that full scan? Thanks in advance! Answer Alth…

How to iterate over PostgreSQL jsonb array of objects and modify elements?

arrays json postgresql sql unnest

Given jsonb array and PostgreSQL 12: Need to convert it to: Is it possible somehow to iterate over jsonb array and downcase only “type” values? I tried: but it separates data and type pairs into separateelements. Answer You need an intermediate level of nesting to rebuild the objects before you ag…

Selecting additional data/values to display as column in query or in form

ms-access ms-access-2016 sql vba

I have an employee index, that I need to run queries on for each employee, and display that output along with the original employee. So say the employee index has an ID, batch, status, and multiple other columns. I have a table where I keep track of every time a column in the employee index changes. I want to…

Is it possible to create a prepared statement and reuse it later with Java under postgres?

java postgresql prepared-statement sql

I am trying to test a few things out with postgres. I want to know if it’s possible to create define a PreparedStatement such as String statement = “Insert into table_one values (?)”; …

Oracle Merge – Can I do something like “When Not Matched Then Delete”?

inner-join merge oracle sql

I have a table (t1) with a unique list of patients. I have another table (t1_Backup) with a duplicative list of patients and details. I would like to essentially perform an inner join to update t1, …

Postgres expand JSON with unkown keys

json postgresql sql

I want to expand a specific row in my table which has a json column with the followingstructure: id|column1 | —|————-| id1|{nested json}| id2|{nested json}| Structure of nested JSON …

Find the sum total of two CASE statements – (How to use a CASE expression or Lateral JOIN

case left-join sql sql-server sql-view

I am looking to find the total profit made on an each way horse racing bet I have created a view to show odds and returns for each part of the bet, but I would like to add another column (EachWayProfit) to find the total profit. I have tried to simply SUM the two case statements though receiving a Syntax