ODBC guide

Read sheet rows by row number

Gets specific rows from a sheet by their row numbers. Supply a comma-separated list of row numbers in the RowNumber parameter within the WITH clause.

SELECT * FROM get_sheet_rows_by_ids 
WITH (
  SheetId=3482072521854852
, RowNumber='1,2,100'
--OR-- (If you supply both Id and RowNumber then only Common Rows selected
--, Id='1312208360476548,6941707894689668,5815807987847044'
)