Stack Overflow
Stack Overflow

Questions tagged [lead]

Accesses data from a subsequent row in the same result set without the use of a self-join in SQL Server 2017. LEAD provides access to a row at a given physical offset that follows the current row. Use this analytic function in a SELECT statement to compare values in the current row with values in a following row.

For further reading https://learn.microsoft.com/en-us/sql/t-sql/functions/lead-transact-sql

309 questions
0
votes
2 answers

Calculate lag string in group

I have a toy electoral db and need to calculate incumbency but cannot using grouped values and dplyr::lag race <- data.frame(city=rep(1,6), date=c(3,3,2,2,1,1), candidate=c("A","B","A","C","D","E"), …
MCS
  • 1,071
  • 9
  • 23
0
votes
1 answer

how to select third, fourth, fifth date in sql using window function

The table rental of movies has this data: rental_id rental_ts inventory_id customer_id return_ts 11909 2/14/2020 871 474 3/15/2020 12222 2/14/2020 3949 22 4/18/2020 how to generate…
ERJAN
  • 23,696
  • 23
  • 72
  • 146
0
votes
0 answers

Power BI Chart Type for lead time

I am looking at Supply Chain Lead Times and would like to reconstruct the BCG graph, linked below. Ideally I would like to show the Mean of each process step (cycle time) on the x-axis and the Standard Deviation on the y-axis. Would somebody please…
Jeiran
  • 15
  • 5
0
votes
0 answers

LEAD AND LAG NOT working in mysql workbench 8.0.22

I have just updated my workbench to latest version just to run lead and lag window functions But it is still giving following error Error code 1305 function lead does not exist
MoinAhmad
  • 21
  • 3
0
votes
1 answer

How to get next row value based on previous row in SQL server?

I have a table as follows, here I want to re-generate the StartDate and EndDate data based on the NumberOfDaystoAdd values, and the StartDate for subsequent rows based on previous row's EndDate + 1day and in this sequence I need to exclude the…
Dennis Xavier
  • 101
  • 1
  • 14
0
votes
1 answer

SQL Server query problem. example is in excel sheet picture

Please see the following pic and i want to convert this formula in SQL Server. in excel sheet M N 15 1 0 16 3 1 17 5 2 18 8 4 19 9 4 N= IF(M16-M15<=1,N15,M16-M15-1+N15 Please see the screenshot for…
Jans
  • 17
  • 4
0
votes
2 answers

Iterative calculation for time series using loops in R

My data is composed of 30 years of observable values for 17 samples. The test dataframe below minimizes the sample depth to three but retains the time series length. Currently, my code only returns the desired calculation for the first column when I…
GreenStudent
  • 11
  • 2
0
votes
3 answers

How to minus by period in another column

I need results in minus column like: For example, we take first result by A = 23(1) and we 34(2) - 23(1) = 11, then 23(3) - 23(1)... And so on. For each category. +--------+----------+--------+-------+ | Period | Category | Result | Minus…
Anton
  • 3
  • 3
0
votes
1 answer

Creating the SQL script that tracks progress of an object

I have a table with this schema: Fruit Truck ID Bucket ID Date ------ ----- --------- ---------- Apple 1 101 2018/04/01 Apple 1 101 2018/04/10 Apple 1 112 …
hasan123
  • 5
  • 2
0
votes
2 answers

Why null value in the table getting error while using lead function

I am getting this error - Error converting data type nvarchar to numeric. I have data coming from a table and I need only two values from the table where I filter only the number (no alphanumeric so used the isnumeric(covrg_cd)=1). The input data…
Deepa
  • 27
  • 4
0
votes
1 answer

built a new column, based on different conditions on three consecutives rows in r

It is possible to build a new column based on 3 consecutive rows, but with different conditions for every row (lag, row, lead)? I already tried several ways, see code below. But with no…
Marta
  • 27
  • 7
0
votes
1 answer

How to find next of next line in a table - oracle SQL

I have a large table and for every line, I show the values of the next line using "lead" function. But i want to show the "next-next", which means the values of the next line of the next line. I can't find a way to do it in one insert query (there…
Ded
  • 21
  • 2
0
votes
1 answer

Lead Lag function not working on Teradata 15.0 .Any alternative method that could give me similar results

MY TABLE DATABASE TABLE I am trying to find the variance between Next In date to Previous out date on EMPL level. Something like this OUTPUT Results The Lag Code i tried using is SELECT …
Sanket Gandhi
  • 5
  • 2
0
votes
1 answer

Confusion over using LEAD/LAG window functions

On this table: SELECT * FROM mytable WHERE id=53388829 LIMIT 10; id | lat | lon | timestamp | travelmode ----------+------------+------------+------------+------------ 53388829 | 41.2371292 | -8.6711092 | 1459516801 | …
user12587364
0
votes
0 answers

SQL Server query with Lead function is taking time

I am trying to execute below code which is taking too much time to execute. SELECT ROW_NUMBER() OVER (PARTITION BY a.DeviceID, a.SubscriberLoginID ORDER BY a.GPSCommandID) Row, a.DeviceId, SubscriberLoginID, CabLatitude,…
Maddy11
  • 1
1 2 3
…
20 21