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…
I have two tables (see below) in a postgreSQL database. Table1 tracks all changes made to each ID (i.e. multiple rows per ID): create table table1(id,record,name,data1,data2,data3)as values (1,1,'Dave', 1.2,55,1) ,(1,2,'David', 1.2,55,1) ,(2,1,'Sam', .8,30,2) ,(3,1,'Jenn', .9,28,2) ,(4,1,'Arthur',1.1,77,1) ,(5,1,'Jim', .7,42,2) ,(5,2,'Jimmy', .7,42,2)…