Select ROW_NUMBER from an excel table

Asked

Viewed 66 times

0

Today I wear 

SELECT * FROM [Plan1$]

To select the Excel spreadsheet data, I would like to know how to select the record row as well.

sql excel

1 answer

0


You can use where to filter the desired records:

SELECT *
FROM [Plan1$]
WHERE [Field_name] = "myFilter"

Browser other questions tagged sql excel

You are not signed in. Login or sign up in order to post.