How can I implement IGNORE NULLS in window functions such as FIRST_VALUE and LAST_VALUE in MySQL? For example, let's say we have a very simple table called sales. SaleID CustomerID SaleRegion 1 7 CITY A 2 10 NULL 3 10…
I have a table that stores member info. The column 'added' stores the date they joined. View Table I want to get the most recent dates in the added column and update them to a specific date. Sometimes it is…
Is it possible to force a SELECT statement on a table to include columns from that table in a WHERE clause, in Postgres? For example, given a table T with columns c1 and c2 can I force a SELECT on…
Here I have query in which I am trying to avoid the negative symbol in the final output. But why do I get that negative symbol ? I have try to use the replace() but it doesn't work. can you…
(I had originally asked this question on the DBA StackExchange, but didn't get much activity in it). In my DB, I have tables for items and connections between them, creating a likely sparse graph, with islands: CREATE TABLE IF NOT…
I have a MySQL table containing users, files and file ages as shown below. Users Files File age A 1 42 A 2 17 A 3 4 B 4 85 B 5 73 B 6 11 C 7 6 C…
I'm using Postgress DB in AWS and creating some views with calculations. I have multiple rows with the same ID but different Units and Subunits. I would like to get a Sum based on Value_1 and Value_2 in the SUM…
i am using this query to get cost of the product select SUM(strg_op.opcost)/ SUM(strg_op.opvalue * 1000) * strg_catgs.Disrate as totalcost from strg_catgs INNER JOIN strg_op on strg_op.ElemID = strg_catgs.elemID and strg_catgs.elemID =( select strg_catgs.elemID where strg_catgs.catID = '13' ) and…
Assume I have two tables related with one to many: Person: - name - age - phone Attributes: - fk - field - value for example Person: id name age phone 1 John 18 null 2 Sue 22 1234567890 3…
I have a PostgreSQL table named entity_changes with the following structure: CREATE TABLE entity_changes ( entity_id INTEGER, raw_time BIGINT, resolved_datetime TIMESTAMP WITH TIME ZONE, old_phase VARCHAR(255), new_phase VARCHAR(255) ); This table tracks changes in the phases of entities over time.…