Question

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

  • 18 April 2022
  • 1 reply
  • 36 views

Badge +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

Userlevel 7
Badge +10

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

Reply