I have a raw table from firebase in snowflake. All the information that I need is in the field "Data" (JSON). Because of that, I created a view to extract all the data in deferents columns. I use json_extract_path_text(data, 'createdAt')…
I have a table with the following format: CREATE TABLE segments(id INT, walk BOOLEAN, taxi BOOLEAN, bus BOOLEAN, subway BOOLEAN, bike BOOLEAN); INSERT INTO segments (id, walk, taxi, bus, subway, bike) VALUES (0,false,false,false,false,true), (1,true,true,false,false,false),(2,true,false,false,false,false), (3,true,false,true,false,false),(4,true,true,true,false,false), (5,false,false,true,false,false),(6,true,true,false,false,false), (7,true,false,false,false,false),(8,true,false,true,false,false), (9,true,true,true,false,false),(10,true,false,true,false,false); SELECT *…
I have a column in my table that contains 10-digit hts codes (0000.00.0000). Some of the values do not have the full stop points (0000000000). How can I add the full stop points to all the rows that do not…
I am new to SQL and having a hard time to filter out a table using SQL query. I have a table as below CATEGORY | NAME | UID | LOCATION ------------------------------------------------------------------------ Planning | Test007 | AVnNDZEGp5JaMD | USER Planning…
I want to create product filter for multiple categories. User will select for ex. Mobile phones category via form select element and then there will be showed options for this category which user can choose, for ex. Color, processor,... And…
Let's say I have the following data table: id | data_1 | data_2 | category 1 | a | A | 1 2 | a | A | 1 3 | | B | 2 4 | b | B…
I have 3 tables: Categories table category_id category_name 1 kitchen 2 bedroom Suppliers table supplier_id supplier_name 1 amazon 2 wallmart 2 ebay Product table product_id product_name category_id supplier_id stock 1 bed 2 1 2 2 table 2 2 10 3…
I wanna select data from table with ordering where first I'll get values with specific value. I tried this but it didn't work: SELECT name FROM test ORDER BY id ='d189463e-52dc-40e5-adf7-eddce74cf05e';
ID POSITION EXPERIENCE SALARY 1 top 90 1500 2 bottom 100 1500 3 top 90 750 4 left 90 1000 5 right 100 1300 6 top 90 1500 7 left 80 2000 8 top 80 1000 9 bottom 100 2000…
I am new to postgres and trying to update the columns where the status is either null or new. The below query is validating for NEW but not for empty string/null value. Is there any way to achieve this? update…