Is there a way to access the “previous row” value in a SELECT statement?

by

Use the lag function:

SELECT value - lag(value) OVER (ORDER BY Id) FROM table

Sequences used for Ids can skip values, so Id-1 does not always work.

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. sql server 2008 management studio not checking the syntax of my query
  3. Split function equivalent in T-SQL?
  4. Querying data by joining two tables in two database on different servers
  5. Is having an ‘OR’ in an INNER JOIN condition a bad idea?
  6. Where value in column containing comma delimited values
  7. How to find all connected subgraphs of an undirected graph
  8. How to use table variable in a dynamic sql statement?
  9. SQL query to split column data into rows
  10. Common Table Expression, why semicolon?
  11. T-SQL split string based on delimiter
  12. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  13. Create Trigger to log SQL that affected table?
  14. How do I find duplicates across multiple columns?
  15. Transfer data from one database to another database
  16. How to find third or nᵗʰ maximum salary from salary table?
  17. SQL “between” not inclusive
  18. Can I set ignore_dup_key on for a primary key?
  19. Selecting first row per group
  20. Using PIVOT in SQL Server 2008
  21. sql varchar(max) vs varchar(fix)
  22. sql group by only rows which are in sequence
  23. Function in SQL Server 2008 similar to GREATEST in mysql?
  24. store arabic in SQL database
  25. Convert Date format into DD/MMM/YYYY format in SQL Server
  26. How to retrieve field names from temporary table (SQL Server 2008)
  27. How to combine results of two queries into a single dataset
  28. When using GETDATE() in many places, is it better to use a variable?
  29. Executing SQL Server Agent Job from a stored procedure and returning job result
  30. Cumulative Total in MS Sql server [duplicate]

Leave a Comment