Hi, I would like to write a query to get the values < 365 from an excel table. The name of the column is "Days in Process". I am unable to give the where condition.

while fetching the data, the row values are stored in the record. so you can specify the By Name or Index

The index always starts with 0

For your cases, Days in Process - index number

For Example- Days in Process is the 1st column that should be 0

I wrote the query like SELECT * From [Table name$$] where Days in Process < 365. That threw an error

I am fetching data from excel