In this course I show you the basics of SQL that EVERYONE who works with data in any way should know. This completely free course covers everything from a simple select statement to basic query optimization techniques and will definitely be a big asset when looking for a job or advancing your career.
In this episode we cover window function. As ou will see on some examples discussed in the video they can significantly simplify your queries and enable some powerful analysis with only few lines of SQL.
Github link to the SQL file from the video [ Ссылка ]
00:00 Intro
00:38 OVER clause
4:44 Partition by clause
9:50 order by clause
14:10 ROW_NUMBER, RANK, DENSE_RANK
18:47 NTH Largest/smallest
22:38 ROWS BETWEEN
