When running this site locally, no problem. I have my server/client in different folders and the server is set to update the database on Heroku. I have one simp
pretty new to teradata and trying to figure out how to repeat a simple insert statement. I have the following statement Insert into Test (Id) values ((sel max (
Trying to link two tables that are in one database please help with syntax
I have following table: Id HieararchyId Name 1 / MHz 2 /1/ Finance 3 /1/ IT 4 /1/3/ Software Development 5 /1/3/ QA 6 /1/2/ Accountant and I want to get data
I'm trying to extract ID values where End_Time for type A is not equal to Max End_Time of each System_Id ID System_Id Type End_Time 1 1 A
I have following table: Id HieararchyId Name 1 / MHz 2 /1/ Finance 3 /1/ IT 4 /1/3/ Software Development 5 /1/3/ QA 6 /1/2/ Accountant and I want to get data
Using the SalesOrderHeader and SalesTerritory tables, write a query to calculate the number of transactions and total monthly amount per territory for each of
I am doing a merge where a string exists in my target table. To this I want to concat a new delta value which is a ; separated string list in my WHEN MATCHED ..
i have a table called "main" which has 4 columns, ID, name, DateID and Sign. i want to create a query that will delete entries in this table if there is the sa
I am currently trying to migrate a T-SQL script to Snowflake. This is the T-SQL script: SELECT * —- a bunch of stuff FROM TABLE_DATE D LEFT JOIN
Departure Destination FlightCount A B 5 B A 4 A C 7 C A 1 I need to find the most frequent flight regardless of the flight directions from the above table. Fo
I want to do a Nested query to add the same data but with different filters. I have tried something like this but that gives nothing or doesn't execute: Select
When you select by a SUM, the returned data is grouped to a single record, which is fine. The query below correctly returns the sum, but the adjacent column val
i have following table and need to get the all rows and the condition end_dt IS NULL OR end_dt >=CURRENT DATE has to apply only for the rows where PLAN_ID i
**The problem was in this code lgin enter image description here You only needed to delete 1 line (<form metod="POST" action="/singup") to make everything wo
From a stock transaction table I've created following sorted view table to be ready for FIFO: rowN date_ stockCode sign_ amount unitPrice 1 '2022-01-20' ABC in
SSRS , I am trying to make a table where the first row will be a aggregate value and remaining rows should be displayed as such from the \DB For Example :
So we have a new project where we need to use postgres 14 to scale up a transaction table that gets heavily updated. The Master table has about a 60 million row
I need to execute a complex query for testing purposes with params. How to write a SELECT query which can be executed in DataGrip / PgAdmin with params: EXECUTE
Can someone help me with this code? I'm trying to match the login account to the activities that conducted and its participants. Thank you in advance for the he