I am performing group by to get the count of every individual value along with the total count. Data, It is very easy to get the count of individual columns using below queries, select name, colour, count(1) from table group…
I want to select data from two tables, category and sub_category. But I only get the column names of category. I want both category and sub_category. Here is the result: { category_id: 3, category: 'GARDEN' }, { category_id: 6, category:…
I would like to perform an operation that aggregates the values of one column based on combination of values in two other columns irrespective of which column they show up in. For example, given this table: a b 10.0 <-…
I am pretty new to this topic. So i have this table: Table "public.client" Column | Type | Collation | Nullable | Default --------------------------+-------------------+-----------+----------+--------- contact_phone | character(11) | | not null | status | character(11) | | not null |…
Getting Connection Lost in coorelated queries. select emp_no,salary from salaries e where 2 = (select count(distinct salary) from salaries p where p.salary>e.salary); I tried this to get second highest salary but its giving me sql connection lost every time. All…
UPDATE accounts SET lastSerialChange = CURRENT_TIMESTAMP WHERE username = 'Jayden'; UPDATE accounts SET serialChanges = '[{"serial":"D06ACE5BBE90E803590D1691FB9254B3","reason":"test","date":1695495618004}]' WHERE username = 'Jayden'; INSERT INTO serial_requests (username, serial, reason, requestedAt) VALUES ('Jayden', 'D06ACE5BBE90E803590D1691FB9254B3', 'test', 1695495618004); I am querying my database with the above,…
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,…