I’m extracting a table of 2000+ rows which are park details. One of the columns is JSON type. Image of the table We have about 15 attributes like this and we also have a documentation of pre-determined codes assigned to each attribute. Each row in the extracted table has a different set of attributes that you can see in the
Tag: redash
Best approach to ocurrences of ids on a table and all elements in another table
Well, the query I need is simple, and maybe is in another question, but there is a performance thing in what I need, so: I have a table of users with 10.000 rows, the table contains id, email and more …
SQL query cannot use NOT LIKE to get results
I am starting out in SQL and am trying to do a query that will select all event names that are unique and do not have ‘TODAY-XXXXXXXX’ in the value for the event_name column. I have a query that works …
Extract substring from column based on values from another table in SQL
In SQL (let’s assume ANSI standard SQL), is it possible to extract a substring from one column, based on another table, and put this substring into another column? Example, from the following tables: The idea is to extract the location from the summary column and output the following: Answer You can do pattern matching: As commented by jarlh ANSI sql