Popular Posts

  • Adding to Lists
    SQLServerCentral » Latest topics Adding to Lists Comments posted to this topic are about the item [B] Adding to Lists [/B] more in...
  • SSMS is Free
    SQLServerCentral » Latest topics SSMS is Free Comments posted to this topic are about the item [B] SSMS is Free [/B] more info... ...
  • The March of AI
    SQLServerCentral » Latest topics The March of AI Comments posted to this topic are about the item [B] The March of AI [/B] more in...

SQLblog.com - The SQL Server blog spot on the web

Loading...

Thursday, September 28, 2017

Window Function Lag() - No previous Value when 1 row.

SQLServerCentral » Latest topics
Window Function Lag() - No previous Value when 1 row.
Hi,

LAG function gives us value which was encountered in previous line.
There is no lag value available for 1 row, and 0 (zero) is returned. Is it possible/Is there a way to return the current value (instead of previous) in this case?
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)