This is a Microsoft SQL tutorial showing how to get the latest record from a table. This tutorial includes nested selects. The example in the video is how to get the latest sales record for each customer.
Complimentary videos:
Nested selects and variables - • MS SQL tutorial on nested selects and vari...
Intro to nested selects - • MS SQL tutorial on nested selects