I am getting 0 row when selecting from OPENJSON below. I am expecting to get all 3 values "AA" for different as_of_date for CREDIT_RTG . I tried different select statements. I am running in SQL 2016. Expected result should be…
I have following table: CREATE TABLE mytable ( id int, name varchar(255), data json ); id name data 1 John ["a", "b"] 2 Pete ["a", "b", "c"] 3 Mike ["a", "b"] Where column data has JSON type, and I want…
Is it possible to use a different start and end time of the day when using the group by clause on the postgres The requirement arose due to the business requirement where shops have different shop open and close hours…
I have implemented a SQL database to track the number of visitors to my website on a daily basis. The intention is to display this visitor count at the bottom of the website. However, I'm facing an issue where the…
I have a table with the following example data: ID Name lat long 1 100 123 -123 2 101 234 -234 4 100-L NULL NULL 5 100-R NULL NULL 6 101-L NULL NULL 7 101-R NULL NULL What I need…
how to set the right index(es) for this schema ? I have a product table where I show at first active products like this: SELECT name, price, categoryid FROM products WHERE status = 1; Then a people can filter like…
It's my custom type. CREATE TYPE salary_info AS ( max_salary numeric, min_salary numeric ); CREATE FUNCTION test_1(city varchar(15)) RETURNS salary_info AS $$ SELECT MAX(salary) AS min_salary, MIN(salary) AS max_salary FROM employees WHERE city = test_1.city; $$ LANGUAGE SQL; SELECT test_1('New…
I have a table like below: id device_id device_model 1 101 A 1 201 B 1 202 B 2 102 A 2 301 C 3 103 A 3 203 B 3 302 C I want to select group of ids…
I have a snowflake table as below table name: raw_data id conv_type transcript 1 chat [{"by":"sys", "text":" can I help you?", "time":"2023-01-01 11:11:11", "comments":""},{"by":"person1", "text":" yes tell me", "time":"2023-01-01 11:12:11", "comments":""}] 2 phone [{"by":"sys", "text":" can I help you with?",…
I have below table with schema , i want to generate some 10K or 20K test data and i want the test data values as per related column data type , anyone can you please suggest on this , in…