I'm use to simple SQL queries and can't get this one. I have a members table that is set like so: member_id | member_number | member_fname | member_name | member_parent_id | member_status member_parent_id is a reference to member_id I need…
The below code works to insert rows into table_main on an mySQL database where table_A contains unique values from the column primary_isbn13 INSERT INTO `table_main` SELECT * FROM `table_A` A WHERE NOT EXISTS (SELECT 1 FROM `table_main` X WHERE A.`primary_isbn13`…
I have to rewrite a SQL query to make it work with PostgreSQL. Initially the end of the query was like returning rowid into ? And with this command took my C# variable as a parameter. But PostgreSQL doesn't have…
I have two tables, TableA & TableB All tables data are available here: db<>fiddle TableA as follows: TableB contains the passed/failed scenario as follows: I want to updating tableA with data of tableB for particular A_id. I'm expecting tableA output…
I'm starting to learn sql in porstgresql. I have create a table with numeric(6,2) structure and trying to import data. But data has some row that has NULL value. Now I'm getting "ERROR: invalid input syntax for type numeric: NULL"…
I am trying to add partitioning to a table in my database. Here is an example: CREATE TABLE IF NOT EXISTS myBd.test_table ( id SERIAL PRIMARY KEY, name VARCHAR(50) NOT NULL, age INT NOT NULL ) PARTITION BY hash (id);…
I am using PostgreSQL DB and have use case where I need to return all the rows from table whose column value is superset of same column value of other preceding rows. Example - the table has following rows: -------------------------------------------…
I need to calculate the (quarterly sessions conversion rate) = (number of orders) / (number of sessions) for an online store. Here is the data table: CREATE TABLE orders_full ( order_id, sessions_id, created_time ) CREATE TABLE sessions_data ( -- records…
Attempt - which returns all registrations that has reportDate = CURRENT WEEK. SELECT * FROM registrations LEFT JOIN reports on registrations.registration=reports.registration WHERE reports.reportDate between cast(timestampadd(SQL_TSI_DAY, -(dayofweek(curdate())-2), curdate()) as date) and cast(timestampadd(SQL_TSI_DAY, 7-(dayofweek(curdate())-1), curdate()) as date) I want to achieve the…
I select data from temporary table: CREATE TEMPORARY TABLE IF NOT EXISTS "tmp" ( "fuel_type" TEXT, "litres" NUMERIC(8,2), "is_rent" BOOLEAN ); insert into tmp values ('petrol', 10, False); insert into tmp values ('petrol', 20, False); insert into tmp values ('diesel',…