In the previous segment, you learnt how to write a simple query using a frame. Now, let’s watch the upcoming video to understand the structure of a frame in depth and learn about its possible constituents.
As you learnt in this video, a query that uses a frame has multiple components. These components are shown in the diagram given below.
You also learnt about the usage of several keywords in the ‘frame’ clause such as UNBOUNDED, PRECEDING, FOLLOWING, BETWEEN and so on. Note that the order of the rows gets reversed when you use the DESC keyword in the query. Now, before moving on to the next segment, try to solve the questions given below to test your knowledge of frames.
In the next segment, you will learn about yet another set of window functions. These are the lead and lag functions.
To learn more about the different parts of a frame, you can refer to the link provided below.