Hi all, I hope you are well. I have a very quick question for you please. I have a table with x rows and y columns. I need to select the top 100 rows ordered by col2 for eg. Further, I need to select only one row for a particular column value. for example, I need to select top 100 rows, order by col2 but grab only the first row where col1 is duplicated(in that order). Iam no SQL pro so is there any advice or pointers you guys could give? Thanks.