My users table lists all users: id name 1 alice 2 bob My users_teams table defines which users are in which teams. id team_id user_id 1 100 1 2 100 2 I want to search for users with a certain name, and also know which team they are on. I select the users first, which

I’m using below PLSQL block within my Oracle ORDS where my current input json body is like below ['123','456'] but i want to change the input json body to below format (unable to decide the logic) [{ "vendorid":123" }] my current working code is like below (for input body [‘123′,’456’]), i’m not understanding how to

We have two SQL tables and . Now, We have to do a merger of these two table in such a way that, table_1 seq_number which is not present in table_2, map with the tp_no = 0 Like this. We have to create this in SQL table so it could be used further. I am

I have three schemas META, DATA and a Custom schema in an Oracle DB. I’ve declared one simple procedure in META schema. CREATE OR REPLACE PROCEDURE TEST1 ( v_name IN VARCHAR2 ) IS BEGIN DBMS_OUTPUT.PUT_LINE('Hello, ' || v_name); END TEST1; / I haven’t given any grants on DATA or CUSTOM schema for this procedure. When

the first sql SELECT rtx , arrayJoin(['Istanbul', 'Berlin', 'Bobruisk']) AS city FROM ( SELECT 'hi' as rtx ) where city = 'Istanbul' group by rtx, city; the result is rtx city hi Istanbul the next sql SELECT rtx , arrayJoin(['Istanbul', 'Berlin', 'Bobruisk']) AS city FROM ( SELECT 'hi' as rtx ) where city = 'Istanbul'

I need to list the columns and tables that are used in the creation of the view [dimension].[v_dim_customer] . To do this, I query the value of the column [VIEW_DEFINITION] which contains the SQL query for creating the view. SELECT v.TABLE_SCHEMA,v.TABLE_NAME, v.VIEW_DEFINITION FROM INFORMATION_SCHEMA.COLUMNS c JOIN INFORMATION_SCHEMA.VIEWS v ON c.TABLE_NAME = v.TABLE_NAME and c.TABLE_SCHEMA =

I have a table Users with id, this table has a million records or more. So when fetching data from the table I am using batching with offset & limit to reduce load on my server. My question is if we are executing the below query of fetching the data from the table, simultaneously a

I have a table which contains data of 1minute time interval of a stock. I need to convert the data into 5min,15min,30min,1hour time intervals and group the columns. I have no idea how to convert time intervals. Can anyone help me pls. date open close 27-09-2024 15:25:00 352.85 352.75 27-09-2024 15:26:00 353 351.95 27-09-2024 15:27:00

I have a table like this: id stage(varchar) 1 ["a","b"] 2 ["c"] and I need to retrieve the data as the following format: id stage 1 a 1 b 2 c How should I write my SQL in AWS Redshift? You need to sign in to view this answers

I know this question doesn’t really belong here, because I ask for an explanation and not for a solution to a problem. If there is a better place to ask it, feel free to redirect me. I understand the difference between column IS NULL and column = NULL in SQL, multiple answers such as this