use dense rank() window function because if we have a multiple people with second highest salary at that point of time dense rank() function will give all the records with second highest salary but with row number() function we will get only one record.
Can we use the MOD function in SQL to find the odd and even numbers?
Can we write a direct query without using the temporary table creation concept?
can you share the datafile too
use dense rank() window function because if we have a multiple people with second highest salary at that point of time dense rank() function will give all the records with second highest salary but with row number() function we will get only one record.
Thanks Rahul, this one serves as a quick recap for my SQL rounds!