I am trying to create a SELECT statement that selects all (*) the fields from a table that meet the following: 1 row for each DISTINCT( client_id, fileno, ppyear) combination, but only including the MAX(ppyear) Based on what I have…
JSONata is honestly driving me crazy. I asked something similar a couple of weeks ago, but I still don't know what I'm doing so here I am again. What I'm working with: [[ { "time": "2024-04-26", "value": 40 }, {…
I have a table in Postgres id title ..... 1 title1 ..... 2 title2 ..... 3 title1 ..... 4 title13 ..... 5 title4 ..... 6 title7 ..... 7 title1 ..... 8 title1 ..... 9 title53 ..... 10 title11 ..... 11…
I have a table as in sample below | C1 | C2 | C3 | C4 | r1 | a | b | c | 1 | r2 | a | b | c | 2 | r3 | c…
I have a transactional database with more than 100 columns. Now if I have to select all the rows but only those columns which have changed down the table (more than one distinct value for a particular column). how can…
SELECT key1, key2, JSON_ARRAYAGG(foo) foo, JSON_ARRAYAGG(bar) bar FROM ( select 1 as key1, 2 as key2, '1.0' as foo, 'A' as bar from dual UNION select 1, 2, '2.0' , 'A' as bar from dual UNION select 3, 4, '2.0'…
I have a table: Rank Title Genre 1 Guardians of the Galaxy Action,Adventure,Sci-Fi 2 Prometheus Adventure,Mystery,Sci-Fi 3 Split Horror,Thriller 4 Sing Animation,Comedy,Family 5 Suicide Squad Action,Adventure,Fantasy Is there any function that I can count how many distinct text contain in…
I have this SQL query: SELECT COUNT(DISTINCT CustomerName) over( ORDER BY OrderTimestamp RANGE BETWEEN INTERVAL 2 hour PRECEDING AND CURRENT ROW ) AS count_per_time FROM Orders WHERE CustomerName IS NOT null AND CustomerName != '' but it doesn't work because…
If I do: SELECT a, a FROM myTable I can get back the "a" value two times, and that's fine, it works. But I want to do something like: SELECT DISTINCT(a) AS a1, DISTINCT(a) AS a2 FROM myTable Of course…
I am trying to count the unique values of a position_id while also satisfy another criteria of "true" in another column. I keep getting all values returned since I am counting them. COUNT(DISTINCT CASE WHEN p.position_id IS NOT NULL THEN…