Supercharge Your SQL Skills with Lead & Lag Functions

Поділитися
Вставка
  • Опубліковано 29 гру 2024

КОМЕНТАРІ • 4

  • @uc7602
    @uc7602 Рік тому +1

    Great video! Enjoyed watching you use of Excel formulas to help code and validate the LAG(), LEAD() and AVG() functions using SQL. Thanks Anthony!

    • @AnthonySmoak
      @AnthonySmoak  Рік тому

      Thank you! I'm glad you like the Excel piece I put in the video to explain the concept.

  • @ifortniteclipz9946
    @ifortniteclipz9946 Рік тому +1

    Hello, I’m wondering if you have or can do a tutorial on creating a parameter table such as start datetime & end datetime and how to incorporate this so a user can input the date and use it to refresh the table being pulled from a database?

    • @AnthonySmoak
      @AnthonySmoak  Рік тому

      Somewhat similar: ua-cam.com/video/7xsL_gHf9Ws/v-deo.htmlfeature=shared