``` select JT.* FROM JSON_TABLE (json_sample) '$.general[*]' COLUMNS ( product_key NUMBER PATH '$.product_key', group_subtype_id NUMBER PATH '$.group_subtype_id', group_subtype_name VARCHAR2 ( 100 ) PATH '$.group_subtype_name', variant_id NUMBER PATH '$.variant_id', variant_name VARCHAR2 ( 100 ) PATH '$.variant_name', rb_customer_id NUMBER PATH '$.rb_customer_id', NESTED…
I have searched on the forums and failed to find how can one name columns for a values statement subquery. Here is my query in MySQL: SELECT * FROM (VALUES ('PPA', 'blah', 30) , ('PPB', 'blah blah', 60) ) AS…
How can I update multiple rows in one query? UPDATE table SET col_1=col_1+5, col_2=col_2+7 WHERE id=12; UPDATE table SET col_1=col_1+2, col_2=col_2+6 WHERE id=16 ... UPDATE table SET col_1=col_1+..., col_2=col_2+... WHERE id=... How to union following queries
I have a SQL table named Rights with the following fields: rightId, RightName, ParentRightId, RightIsActive. The RightName field contains the name of each right, including its parent rights separated by underscores. For example, if right 3 is a child of…
How do I get the rows for each year by scenario that are associated to the latest scenario for each year while being at-most prior month (future budgets & forecast scenarios exist as well) Fields: scenario (VARCHAR) Distinguishes between budget…
I need to update each row in a table with a value returned by a function. This function uses a separate columns value of the same row. I understand how to select a columns value from a row and how…
I need to adjust the following select statement to effectively filter out 523 records where 'first_date_purchased' is less than 'first_date_watched'. The following select statement returns 20778 records, of which 20255 should remain. SELECT se.student_id, si.date_registered, MIN(se.date_watched) AS first_date_watched, MIN(sp.date_purchased) AS…
In Postgres, does the EXISTS operator have the highest precedence of all? For example: SELECT 1 + EXISTS (SELECT 1)::int; It seems to be missing from the manual page. Though the highest one is ::, meaning EXISTS would be higher?…
I have code: CREATE TRIGGER update_after_requirement_on_description BEFORE UPDATE ON requirement FOR EACH ROW BEGIN IF !(NEW.description <=> OLD.description) THEN UPDATE requirement SET NEW.description_previous = OLD.description; END IF; END; and second one: CREATE TRIGGER update_after_requirement_on_description BEFORE UPDATE ON requirement FOR EACH…
I'm working on a SQL solution to squeeze the number of rows when there are matching "start" and "close" values across records. Here is an example input and the required output Input name start close A 120 130 A 130…