I am trying to perform a complex query against a SQL Database in VB6 using ADO.
Basically this is what I am looking for;
Select all records from the table, ordered by ImageDateTime DESC and grouped by key1, then I want to skip the first xx records of each group.
Trying to figure out this syntax is making me OLD :)
Any help would be appreciated.
View Complete Post