Tag: postgresql

I have a table like this I need to get values for a given ID like this is There any simple way to achieve this. Answer You could convert the row to a json & then use json_each to transpose the data as you desire:

I’m designing a SQL database and I’d like to make sure my schema is as strict as possible. Is there a way to require that an array column doesn’t contain null elements? As I understand it, I can make the whole column NOT NULL, but that’s not the same thing since an array of null elemen…

Given a table: I need to set 0 for every ID in where-clause along with IDs: Result What query can I use here? Upd1: let it be Postgres. Upd2: can I do it without joins? Answer You didn’t mention your DBMS, but the following is standard ANSI SQL: It’s possible without a join, but that doesn’t…

I have a simple problem that I dont know how to solve in sql. I have two tables, cost : second table: income Now i want to get a result that substract for each party A, B, C the income-cost and finds the net value. I cannot compare the column header to column value. I am quite new to this,

I have Event_No, Events, Date Range in my table like below. I need to show Min datetime respective Event name with ‘IN'(a concatenation of (Event-‘IN’))and Max datetime respective Event with Out(a concatenation of (Event-‘Out’)). I need My Final Output like below Thanks Answer Th…

So been trying to run a query on a big table but it’s taking more than a day to finish, when I put explain at the beginning and went through the result, it did not appear as using an index The query …