VB6 uses ADO and ODBC to get to any database. The SQL is whatever your database needs to see. Data is returned via recordset objects. If you want to iterate through the rows, use the recordset.movenext method. Another alternative (and faster) is to push all of the results into a 2 dimensional variant array by using recordset.GetRows - then loop through the array. The first index is the column number and the second is the row number. Both indexes will be 0-based.
Bottom line is that you should search for help on the ADODB.RecordSet object.