New to databricks SQL - where clause issue
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2023 10:49 PM
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"
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2023 08:53 PM
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 ' '.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-16-2023 09:29 PM
Hi @Debayan Mukherjee
Thanks, unfortunately though I re-wrote the query from scratch and it's still not returning a result.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-12-2024 07:13 AM
Hi, were you able to get this figured out? I am having the same issue.