In this video, you will learn to use RANK() function in SQL Server. RANK () is one of the four Ranking Functions that are available in SQL Server. 1. ROW_NUMBER() 2. RANK() 3. DENSE_RANK() 4. NTILE(N) In one of our previous videos we have already discussed about ROW_NUMBER() function, you can watch that video here: https://youtu.be/mihn6z5sLo0
In this video, you will learn to get back truncated data using backup and restore mechanism.