cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

New to databricks SQL - where clause issue

Cblunck
New Contributor II

Hello community,

Using Databricks SQL for the first time and I was hoping I could just copy and past my queries from SSMS across and update the table names, but it's not working.

Found it's the where statement, which I updated the ' ' to " " but still no luck. Below is a snip of the column with some values in it and my WHERE statement. Returns 0 rows though...

What is going wrong here?

where t517f215_paye_tax_category = "GROSS"

image.png 

3 REPLIES 3

Debayan
Esteemed Contributor III
Esteemed Contributor III

Hi, Could you please recheck the format, sometimes copying mismatches the format, also, please refer: https://docs.databricks.com/sql/language-manual/sql-ref-syntax-qry-select-where.html . It has to be ' '.

Cblunck
New Contributor II

Hi @Debayan Mukherjee​ 

Thanks, unfortunately though I re-wrote the query from scratch and it's still not returning a result.

image

justinghavami
New Contributor II

Hi, were you able to get this figured out? I am having the same issue.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.