cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
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
Databricks Employee
Databricks Employee

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.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group