SQL QUERY replace NULL value in a row with a value from the previous known value

by

If you are using Sql Server this should work

DECLARE @Table TABLE(
        ID INT,
        Val INT
)

INSERT INTO @Table (ID,Val) SELECT 1, 3
INSERT INTO @Table (ID,Val) SELECT 2, NULL
INSERT INTO @Table (ID,Val) SELECT 3, 5
INSERT INTO @Table (ID,Val) SELECT 4, NULL
INSERT INTO @Table (ID,Val) SELECT 5, NULL
INSERT INTO @Table (ID,Val) SELECT 6, 2


SELECT  *,
        ISNULL(Val, (SELECT TOP 1 Val FROM @Table WHERE ID < t.ID AND Val IS NOT NULL ORDER BY ID DESC))
FROM    @Table t

More Related Contents:

  1. Select rows which are not present in other table
  2. NULL values inside NOT IN clause
  3. Sort by column ASC, but NULL values first?
  4. Why does Oracle 9i treat an empty string as NULL?
  5. Not equal != operator on NULL
  6. SQL is null and = null [duplicate]
  7. Why does NULL = NULL evaluate to false in SQL server
  8. NULL in MySQL (Performance & Storage)
  9. Create unique constraint with null columns
  10. Best way to check for “empty or null value”
  11. why is null not equal to null false
  12. Return a value if no record is found
  13. Sorting null values after all others, except special
  14. Sort NULL values to the end of a table
  15. Determine Oracle null == null
  16. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  17. Why doesn’t SQL support “= null” instead of “is null”?
  18. Combine two columns and add into one new column
  19. IN Clause with NULL or IS NULL
  20. SQL not displaying null values on a not equals query?
  21. Check if NULL exists in Postgres array
  22. Check if a parameter is null or empty in a stored procedure
  23. SQL Inner Join On Null Values
  24. Space used by nulls in database
  25. SET NOCOUNT ON usage
  26. How can I get column names from a table in SQL Server?
  27. What mysql database tables and relationships would support a Q&A survey with conditional questions? [closed]
  28. EXISTS vs JOIN and use of EXISTS clause
  29. How much disk-space is needed to store a NULL value using postgresql DB?
  30. UNIX_TIMESTAMP in SQL Server

Leave a Comment