I was provided a .sql script containing a query to create a table. I trust the source of the script, so I am wondering if the problem is how/where I'm running it. I'm running it in psql, using a call…
I have a table that read day_sunday, day_monday, etc... So I need to check that for today's column if value is true then what data is stored. For example 17 may => Wednesday so the query will be select *…
I have a log table "table1" with values appended every day and need to find "column3" values and dates from "column1", for which the data wasn't recorded. For example, my table looks like this: column1 column2 column3 2022-07-14 274,5 markus…
I have a table uploads_table: upload_id value A [{"doc_name": "doc1a", "doc_type": "pdf"}, {"doc_name": "doc1b", "doc_type": "csv"}] B [{"doc_name": "doc2a", "doc_type": "csv"}, {"doc_name": "doc2b", "doc_type": "csv"}] C [{"doc_name": "doc3a", "doc_type": "pdf"}] What would be the Postgres query to return all the…
I have the following data: create schema test_schema; create table test_schema.joinedDf(id long, firstName text, lastName text, age Int, month Int, salary decimal); insert into test_schema.joinedDf(id, firstName, lastName, age, month, salary) values( 1111, "Peter", "Ivanov", 29, 10,300000.0000000000), ( 1111, "Peter", "Ivanov",…
In a MySQL database table, among other records, there is a number of pairs differing by the value of just one column, like: | FirstName|LastName |Number| | -------- | ------- |------| | John | Smith |15 | | John |…
How do I calculate these two aliases and show them in other columns? SELECT SUM(qty1) AS ali_qty1, (SELECT SUM(qty2) FROM table2 WHERE col2 = 'B') AS ali_qty2, (SELECT SUM(ali_qty1) - SUM(ali_qty2) as total_qty) FROM table1 WHERE col1= 'A' table1 ID…
I have the below table of updates..... refer event_date column detail event_type cat1 2 yesterday abc type 3 cat x 2 last week abc3 type 11 cat b 2 today abc123 type 4 cat a 2 last month xyz type…
Let's assume following data: id parent_id 1 null 2 null 3 1 4 1 5 1 I'd like to return all records where parent_id is either null or "distinctized": id parent_id 1 null 2 null 3 1 Thanks!
I have drawn a simple ERD: The query I perform: select s.*, count(c.store_id), count(p.store_id) from store s inner join customer c on c.store_id = s.id inner join product p on p.store_id = p.id group by s.id, s.store_name, s.address The result:…