I try to pass argument $1 to jsonpath-expression: SELECT 1 FROM %s.orders AS O WHERE order_info @? '$.items[*] ? (@.ProductID == $1)' but it doesn't work. P
I have the query below and keep getting a divide by 0 error but I'm not sure how to add something to bypass that select x.year, x.month, x.period, coalesce(
I have two columns price and sold_count for the product table. How do write sql query to find the top 3 shops having highest Revenue (calculat
What is the solution if you see the code below there is a value (2000) then I want to change it to textbox so I can custom value. Thanks jack Dim sql As String
My company recently migrated to Redshift from Redash recently and I'm having a hard time recreating the YEARWEEK() function available in MySQL but not in Redshi
I have two tables, Semester1 and Semester2. Semester1: StudentId SubjectId abc sub1 def sub1 ghi sub1 Semester2: StudentId SubjectId abc changedSub1 def sub1
How do I optimize these queries to be one or two? The one in the loop to be one at least. $applicantIds = \DB::select()->from( 'applicants' )->where( 'cre
I want to remove the first word from a large string in SQL Server. Input string: 931078027 BP 16:20:0:13 25 BAG 'B' CLASS Desired output: BP 16:20:0:13 25 BAG
I have a single database table on a relational database. Data will be loaded into it. I then want to have multiple servers processing that data concurrently (I
I have a couple tables (see reproducible code at the bottom): tbl1_have id json_col 1 {"a_i":"a","a_j":1} 1 {"a_i":"b","a_j":2
I have a table with 122 columns and ~200K rows. There are duplicate rows in this table. What query can I use to return these duplicate rows? Normally I would GR
I want to get rid of the filter and put it in the request body. I tried using where, how can I do it? Questionnaire entity like: @OneToMany(() => LikeEntity,
Is there a best way to get data from snowflake to s3. ? the data snowflake shows will be in s3, but we don't have access to that bucket. And we only need to ge
I'm using SAS and I'm stuck when I want to relay this in SQL : I have a column that counts the number of line repetitions : DUPLICATES | NUMBER | DATE ------
I connot able to filter the current user record. I want to display the data of current user only. But I did not understand how to handl query. here is the ss of
I have some data like this: ID Value1 Value2 Value40 101 3 520 2001 102 29 530 2020 I want to take this data and convert in to a KV style pair instead ID Val
I have this stored procedure that selects the top 10 results from its inner join CREATE PROCEDURE SP_SELECT_DOCS_WHERE_JOBID_STATUS @JobID INT, @BatchID
I have a table that gives me data every month and I need that range of time. I noticed that sometimes I don't have data for 3/4 month but I need to duplicate th
I have a staging table which contains all varchar columns. I want to validate a date stored in the data column. Since my staging table contains all varchar colu
I have a table that gives me data every month and I need that range of time. I noticed that sometimes I don't have data for 3/4 month but I need to duplicate th