Postgres table have one column as JSONB with below format { "steps": [ { "step": "Building", "status": "Complete", "end_date": "03/08/20
I am trying to create a column that shows Yes or No based on a set of conditions. If the conditions are met, then 'Yes' would apply to every row in the group (e
I have this Postgres code CREATE PROCEDURE adjust_available(patientBed UUID) LANGUAGE SQL AS $$ UPDATE bed SET available = false WHERE bed.id = pati
I'm using TypeORM. Via Repository/Entity pattern and findOneOrFail, I want to select a specific column (isBusiness) only for my results. this.userProfile.findOn
CREATE TABLE EventLog ( EventID INT , EventName VARCHAR(50) NOT NULL , EventStartDateTime DATETIME NOT NULL , EventEndDateTime DATETIME NULL ) INSERT IN
I want to implement R's ceiling_date fucntion in SQL (Postgresql). So I have dates in a column for everyday with corresponding sales and I want to accumulate th
I have two tables: post table: |post_id | post_title | +--------+------------+ | 1 | Post 1 | | 2 | Post 2 | | 3 | Post 3 | post_cre
I need to return elements from a database query based on an inequality using the lexicographic ordering on multiple columns. As described in this question this
I'm trying to get the total duration of membership types (member&casual) another application of the same problem would be to get the total count of the popu
I am trying to insert real-time data from a financial service provider into Excel, which can only be fetched with an Excel-plugin in blocks of roughly 100,000 v
Like date count users 2 jan - 7 feb 2 feb - 7 march
We have a list with a sequence number. The sequence will break, then begin again. As you can see below, the SalesOrderLine is missing the number 4. SalesOrder
I have a table like below, and want to create a new column that contains a list of values from another column subsequent rows like below, for copy paste: time
The question is simple How can i turn this SQLciper GUI Into lines of code either in SQLciper CLI or using a python module ? Here's what i've tried (FAILED ATTE
According to the postgress documentation a collation can be created to ignore cases during comparison operations. CREATE COLLATION IF NOT EXISTS case_insensitiv
I can use: show columns in table_name but this does not allow me to use the output in a query? This throws an error: SELECT * FROM show columns in table_name
I would like to be able to recursively find all relationships in a table. I have a relational table, and essentially I would like to apply the transitive proper
I'm working with Cloud Function. I have the following query working correctly: # this is working q = """ SELECT col1, col2 FROM `my_table` WHER
I want a SQL query that prints a list of employee names who have been employed for less than 10 months having salary>2000. Sort this result by ascending emp_
How to get the dv/dt of the below table in psql Concept is linear regression - but to determine the slope is the what I am facing issue with. voltage || time