Given a directed acyclic graph shaped like this: "Branch A" "Branch B" branch-a-head-id branch-b-head-id --- | | ^ id-Z id-C | | | | id-Y id-B | | | "Branch A" id-X id-A and | | "Branch B" branch-a-first-id branch-b-first-id…
I have a table CREATE TABLE cities ( id serial, name character varying(30) ); Then, some rows were added. In order to make the queries faster, an index was defined: CREATE INDEX cities_name_idx ON cities (name); SET enable_seqscan TO off;…
I want to get the next 10 values of the SEQUENCE at once. I can get those individually by calling SELECT setval('myseq', ...); -- Next nextval will return 43 10 times back to back. On Microsoft SQL server, I can…
I'm working on an exercise from "Murach's MySQL 3rd Edition" which gives the following prompt: "11. Write a SELECT statement that uses an aggregate window function to calculate a moving average of the sum of invoice totals. Return these columns:…
I've a simple query that is taking way to much time to process, the query is very simple and the WHERE clause has just simple comparators but the query takes between 15 to 20 secs to process in a 256gb…
I'm trying to use a case function with a window function, but the data I'm getting doesn't add up. Everything seems to work, but I'm only receiving "Above Average" for that entire CASE function, so I know something isn't quite…
I'm using an ORM to access my SQL database from my Node JS application, and was wondering what the industry standard best practices are to perform SQL operations (some of which might be too advanced for the ORM.) Scenario 1…
I have a user table as follow: CREATE TABLE `user` ( `Id` bigint NOT NULL AUTO_INCREMENT, `FirstName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL -- more column ); Now when I run the following procedure: CREATE PROCEDURE myProc ()…
PostgreSQL version: PostgreSQL 14.8 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit I'm trying to create a stored procedure which accepts two arguments (a and b is for the sake of simplicity, their actual names are _service_id and…
Can anyone please help me with an SQL query which will allow me to populate the real_name column in table 1 with values from both first_name and second_name columns in table 2 by referencing the usernames. TABLE 1 audit_username real_name…