How to SUM numbers from a plain jsonb array? – Postgresql
I'm facing issues with a jsonb ARRAY column in PostgreSQL. I need to sum this column for each row. Expected Result: index sum(snx_wavelenghts) 1 223123 2 223123
How to insert a boolean value to a table in PostgreSQL?
I come from MySQL to PostgreSQL then, I created test table with BOOLEAN state column in PostgreSQL as shown below: CREATE TABLE test ( state BOOLEAN -- Here ); But, I couldn't insert TRUE with 1 and FALSE with 0…
How to find parcels that are bordered with my parcel on Postgresql
My problem is: I have 1000 parcels and 1 of them is mine, what I have to do is to find which are my neighbourhoods which means whose parcels are touched with my parcel. The perfect example is showed on…
Counting 3 columns with yes and no values together in MySql
The table has columns English, Spanish and French. Each with yes or no values and i want to count the number of yes and no for each column into one table. I tried using distinct count but it cannot put…
How can I convert this Json array in SQL Server?
I have an array like this and I want to extract its count into a single array. Can I do this in SQL Server? [ { "ItemName": "ITEM1", "Details": [ { "column1": "2021/Apr", "Count": 10 }, { "column1": "2021/May", "count":…
How to sum non-null values from multiple columns (workaround for CASE WHEN limitation) Postgresql
So I essentially want to work around the fact that CASE WHEN stops executing when it finds its first TRUE return. I'd like to sum every instance of a non-null value between multiple columns, and group these based on my…
how to generate a table in postgresql so that one column's value can be generated based on another column value
I'm trying to make a table in which I can generate a column value based on another column value. For instance: id (primary key)(identity)(int) temp_id (varchar) desc (varchar) 1 temp1 hello 2 temp2 hello brother temp_id column's value should be…
<PostgreSQL> How can I get all the columns of my table based only on a field having the most count?
For example I have a Product table with count, but I would like to display only the values of the top 3 products based on the sum of their count. Product Date Value Product 1 2022-12-01 200 Product 1 2022-12-02…
Enforce subset relationship in postgres – Postgresql
How can I enforce the following business logic in my database schema, without using application code: a user must belong to exactly one company a company can have multiple vehicles a vehicle can have multiple companies a user can have…
SQL Server : parsing a JSON column with irregular values
I have SQL Server 2016 (v13) installation where I am trying to parse a column with JSON data. The data in the column RequestData is in the following format: [ { "Name": "SourceSystem", "Value": "SSValue" }, { "Name": "SourceSystemId", "Value":…