How do I remove square brackets and commas from ["000-000-0000-000","000-000-0000-000","000-000-0000-000"] in sql amazonredshift I tried ltrim it didn't work. It prompted me to use cast function. Not sure how should I use cast function here.
I was creating table name "tripsdata" in SQL query tool, which is done successfully. Now I have to insert values into the table and I used the below syntax : LOAD data INFILE 'tripsdata.csv' INTO TABLE tripsdata FIELDS TERMINATED BY…
I am trying to fetch this query in batches at it contains calculated values before I insert it into another table. So I declare it to fetch in batches. It seems there might be an issue with cursor naming conventions…
I am executing the below query in PostgreSQL but it is taking more time than oracle. In PostgreSQL it is taking 1.5 second and in oracle it is taking nearly 0.009 second. select ex1.currency_id, ex1.underly_currency_id, ex1.type_id, ex1.third_id, ex1.market_third_id, ex1.exch_d, ex1.daily_dflt_f,…
I am facing a problem with a SQL query, which takes around 500ms when queried using RAW SQL (retrieve all data without limit). However, using the same query in laravel(tried Eloquent, DB builder and RAW) it takes around 15 seconds…
I'm getting data from the posts table and there is a likes table that is related to this. I want to know how many likes each post has. I followed an example, but this way it gives an error. I…
I have DB with 4 tables. I have to use 3 of them. Is it possible to change LEFT JOIN statements with only WHERE statement? Database scheme My code block with LEFT JOIN statements: FROM reader LEFT JOIN copy ON…
My subquery = select *,rank() over(partition by city order by hourly_pay desc) from persons as a; My whole query = select * from ( select *,rank() over(partition by city order by hourly_pay desc) from persons ) as b where rank=1;…
Let's assume below table orders_daily_data in which we store number of orders made for a given product across the time: ID ProductType Orders OrderDate 1 sugar 5 2023-01-04 2 flour 0 2023-01-04 3 pepper 7 2023-01-04 4 sugar 1 2023-01-05…
I have 3 tables: conversations participants contacts participants is many to many between conversations and contacts. It has contact_id, and conversation_id. I want to write a select query that takes one or more contact_id values and returns a record from…