I have a SQL query that fetches one row (LIMIT 1) for a specific client code from the TABLEA based on several conditions. Here's the query: SELECT `TABLEA`.`client_code` FROM `TABLEA` WHERE ( `TABLEA`.`accounting_date` = 202408 AND ( `TABLEA`.`FLAG1` = ''…
I am trying to create a SQL statement that will allow me to paginate users calculated performance results. Any help would be greatly appreciated. Here is a mock up of what I am trying to do: I have 4 tables..…
I am trying to find the MIN and MAX of a simple data set.... Score 15 12 8 28 5 Simply doing this would work. SELECT MIN(Score) AS minScore, MAX(Score) AS maxScore FROM Scores; Which should return 5 and 28.…
I have a table that contains ~ 100.000.000 records. In this table, there's a varchar(30) column that contains the license plates of cars. I'm joining this table with another table that contains the same amount of records. I need to…
I'm writing a solution for a DataLemur SQL question and I almost had it right but there is one row missing. I have written this query myself: WITH CTE AS ( SELECT user_id, transaction_date, DENSE_RANK() OVER (PARTITION BY user_id order…
I have a query (PostgreSQL 15.4) like this: Select p."prodId", p."prodDesc", p."areaName", x."location1" as "Location" From ops."Products" p Inner Join ops."Locations" x on p."prodId" = x."prodId" and p."areaName" = x."areaName1" Here's the caveat: in the table Locations, there are three…
I have a table like below: ID NextID 1 5 2 NULL 3 6 4 7 5 8 6 9 7 NULL 8 NULL 9 10 10 NULL I want to get the ID path: 1 --> 5 --> 8…
I am working on a middle size web application that handles projects, invoices etc. I struggle to optimize my filter query for a list of projects whenever I filter by subject's substring. It sometimes searches for up to one whole…
As the title describes I want to have a zero-or-one to zero-or-one relationship. For example, let's say we have two tables Calls and Files. A call might have an attached file on it, and vice versa. But I have a…
I now how to create the procedure but do not know how to call the procedure this is what I have done. Created the procedure : CREATE PROCEDURE SelectAllCustomers AS SELECT * FROM Customers GO; I have created it but…