How to use distinct option in Query

[Nandhu_Rajesh]

Hi,

Since my Excel is having 50,000 Values. I am taking to DB and Fetch the Value. I just need a single column value which should avoid duplicate values.
I am trying using Distinct Option. But unable to fetch it.

Please Help me in this.

 

[otonx]

https://www.w3schools.com/sql/sql_distinct.asp

 

[Nandhu_Rajesh]

https://www.w3schools.com/sql/sql_distinct.asp

Hi Otonx,

I have tried but in OLEDB, it shows too many parameters matching.

 

[otonx]

Hi Otonx,

I have tried but in OLEDB, it shows too many parameters matching.

Please send screenshot of the error here.

 

[Nandhu_Rajesh]

Please send screenshot of the error here.

Thanks for your response.
The issue is solved by using "SELECT distinct[Columnname] FROM [Sheetname$] "

 

[Priyanka13]

This issue can be resolved by the Distinct keyword in SQL. Read more about it here