I have 2 tables with a one-to-many relationship and want to fetch data with single query. Table structure: Employee PK : #Emp-PK SK : #Emp-SK Name : "Test" Table structure : Employee-projects PK: #Emp-PRO-PK SK: #Emp-PRO-SK EmpPKKey: #Emp-PK EmpSKKey: #Emp-SK…
I translate t-sql code to PostgreSQL. I have temp table, which structure i can't change. This table have only index without PK. In t-sql to update columns in this table i using this: update t set col_1 = tt.val from…
I have 2 table CREATE TABLE json_data_table(d_id int, d1_json json, d2_json json); CREATE TABLE user_data(uid int, username varchar); and data respectively are INSERT INTO user_data VALUES (1,'test_user_1'), (2,'test_user_2'), (3,'test_user_3'); INSERT INTO json_data_table VALUES (1,'{"stage1":1,"stage2":2 }', '{ "stage1": { "date": "12-01-2023",…
So I have a table 'A' with has column of numerical values of 12 digits, now there is another table 'B' which has only first 6 digits of the same numerical value, I want to join both the tables using…
the base table is TABLE_1. I want to "join SUM values" from TABLE_2 to TABLE_1 based on columns NUMBER and TOOL like IMAGE below. IMAGE I ve tried to use LEFT JOIN but didnt get result like this in IMAGE.…
I have two tables info and sell_info. info table contains "list of record" and sell_info contains "product which are on sale". I want to get "lowest" value of record where id = 1. How can i do this? Here is…
I have 3 tables in a database A, B and C which share the same column "name". B has an attribute "title" and C has an attribute "age". I am looking to write a SQL query where I will have…
UPDATE table1 alias1,table2 alias2 SET alias2.CURRENT_CD_BALANCE = alias2.CURRENT_CD_BALANCE - alias1.ORIGINAL_AMOUNT , alias1.COMMENT = concat('Sum of ',alias1.ORIGINAL_AMOUNT,' Cancelled') , alias1.BALANCE = 0, alias1.ORIGINAL_AMOUNT = 0, TRAN_TYPE = 'D' WHERE alias1.STORE_ID = alias2.STORE_ID AND alias1.ACCTNO = alias2.ACCTNO AND alias1.AR_TRANS_ID = value1; Query…
I have the table contacts which contains duplicate records: id name is_contacted created_at I need to delete duplicates, but keep the first record(among the duplicates for each name) where is_contacted=1. If among the record duplicates there are no records where…
I have 2 json files and i am deserializing them separately in blazor c#, how can i make a join. so i can show country name also in page. eg AN = Netherlands . json file 1 is below {"CountryIso2":"AF","CountryName":"Afghanistan"},{"CountryIso2":"AN","CountryName":"Netherlands"}…