Imagine after running a query like this:
SELECT ContactName, Country FROM Customers ORDER BY Country
on Northwind database and getting following result:
ContactName Country Patricio Simpson Argentina Yvonne Moncada Argentina Sergio Gutiérrez Argentina Georg Pipps Austria Roland Mendel Austria Catherine Dewey Belgium Pascale Cartrain Belgium Anabela Domingues Brazil Paula Parente Brazil Bernardo Batista Brazil Lúcia Carvalho Brazil Janete Limeira Brazil Aria Cruz Brazil André Fonseca Brazil Mario Pontes Brazil Pedro Afonso Brazil Elizabeth Lincoln Canada Jean Fresnière Canada Yoshi Tannamuri Canada ...
You’re asked to retreive only the 2nd and the 5th group of contacts. How do you do it? Continue reading 'Select specific groups using DENSE_RANK'»