ODBC guide

Read sheet rows by ID

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

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