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…
Connection error default connection me and a friend are making a project for college and he just sent me the final thing so i can show it in my computer but when i want to run the MIGRATE command that…
I need to get list of transactions with list of logs and tags inside each transaction and the most important make search by field in logs and tags and unite it all. Example below is search by field1 and tag1.…