I typed the following SQL code in DB Fiddle using PostgreSQL v14 as the database engine to create the QUESTION relation. CREATE TABLE QUESTION ( ID TEXT PRIMARY KEY, SurveyScreenID TEXT, QuestionNumber INT, QuestionText TEXT ); INSERT INTO QUESTION (ID,…
I don't want to replace ALL dashes in a string, but rather replace only those dashes that are part of a GUID/UUID. Before the replace: Mary-Anne Smith is a physics professor at the University of Illinois. Her dissertation was focused…
I have a table of time periods with an active incident in the format: Incident_Start Incident_End 1/1/2022 01:05 1/1/2022 03:00 1/2/2022 05:00 1/5/2022 12:34 2/5/2022 13:00 2/6/2022 16:22 ... ... I now need to transform this into a table of…
How is it possible that when I try to add a unique constraint named "serveurs_domain" it says I can't because the constraint already exists. BUT, when I try to drop the constraint "serveurs_abbr" it says it doesn't exist. I'm confused…
Given two columns (Animal and Name) how do I write a SQL statement that finds the rows that don't have a 1 to 1 relationship i.e. Dog = Patch and Dog = Rover ? Animal Name Dog Patch Cat Sylvester…
Is ther any clear way of doing the following in one SQL (PL) code? :) What I have in the tables is the following: CONTACT_TBL (HEADER) CONTRACT_ID BEGIN_DATE END_DATE TOT_AMOUNT 123 13-MAY-16 12-MAY-34 100 456 13-JAN-14 12-DEC-25 300 789 13-SEP-14…
How to List the largerst city population for each country -- Use country column (not country_code), order the results by the decreasing largerst city population. enter image description here
Write a sql query that prints domain interest and number students who are interested in that domain. +------+----------+----------+ | sno | sub1 | sub2 | +------+----------+----------+ | s1 | ds | networks | | s2 | os | ds |…
I am trying to ingest several tables incrementally in a pipeline on Azure Synapse using a ForEach Activity. I have defined a variable as an array of strings. Each string corresponds to the name of a table that I want…
I have a query like this Select a.ordernum, a.region, c.area, a.branchname, a.stagename, sum(case when b.entrydatetime is not null THEN 1 ELSE 0 END) as 'Total Count', sum(case when DATEDIFF(day, b.entrydatetime, GETDATE()) <=1 THEN 1 ELSE 0 END) as 'WITHIN 1…