Skip to main content
Question

Hello All I have excel in which 2 column has same name but the values are different . how to query using select statement

  • April 18, 2022
  • 1 reply
  • 47 views

Forum|alt.badge.img+4
Hello All I have excel in which 2 column has same name but the values are different . how to query using select statement

1 reply

Forum|alt.badge.img+12

Hello,

 

This is to inform you that it's not recommended to use the same column name in excel because we will not be able to fetch the data or insert the data properly.

 

But still, you can try using the below query which might help:-

 

select * from Sheet where column='value'

 

If you have any questions please let me know.

 

Thank you,

Prabhakar Jha


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings