SQL difference between rows

by

This is one way to do it 

with cte as
(SELECT
   ROW_NUMBER() OVER (PARTITION BY table.name ORDER BY id) row,
   name,
   score
 FROM table)
SELECT 
   a.name ,
   a.score - ISNULL(b.score,0)
FROM
   cte a
   LEFT  JOIN cte b
   on a.name = b.name
    and a.row = b.row+1

More Related Contents:

  1. What are the options for storing hierarchical data in a relational database?
  2. Is there any rule of thumb to construct SQL query from a human-readable description?
  3. How can I list the tables in a SQLite database file that was opened with ATTACH?
  4. In MySQL queries, why use join instead of where?
  5. Doing a WHERE .. IN subquery in Doctrine 2
  6. Transpose latest rows per user to columns
  7. Is there any boolean type in Oracle databases?
  8. A beginner’s guide to SQL database design [closed]
  9. Physical vs. logical (hard vs. soft) delete of database record? [closed]
  10. SQLite – ORDER BY RAND()
  11. The Next-gen Databases [closed]
  12. SQL Between clause with strings columns
  13. Insert an image in postgresql database
  14. Do database transactions prevent race conditions?
  15. Database EAV Pros/Cons and Alternatives
  16. Conditional logic in PostDeployment.sql script using SQLCMD
  17. Is there a difference between Select * and Select [list each col] [duplicate]
  18. Does an empty SQL table have a superkey? Does every SQL table have one?
  19. How to sum up time field in SQL Server
  20. How to show row numbers in PostgreSQL query?
  21. SQLite3 UNIQUE constraint failed error
  22. How to do an INNER JOIN on multiple columns
  23. Using SQL Server as a DB queue with multiple clients
  24. Upsert with a transaction
  25. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  26. Relational Data Model for Double-Entry Accounting
  27. Creating a custom ODBC driver
  28. Do conditional INSERT with SQL?
  29. Temporal database design, with a twist (live vs draft rows)
  30. Executing SQL query on multiple databases

Leave a Comment