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
I have one JSON column in my table. I want to filter by this column using sqlalchemy with Python and MySQL. I've tried in this way, but unsuccessfully. My colum
How primary key in one table connect to another table with the same primary key? I am trying to make it like this, which those two primary key in the table of C
I have a table with thousands of rows. One of the columns does not read the values correctly. Some letters cannot be recognised and thus changed to some symbols