In PostgreSQL I have: SELECT * FROM weather_data WHERE parameter_type = 'TEMPERATURE'; I want to write this as: WITH ParameterType AS (VALUES ('TEMPERATURE')) SELECT * FROM weather_data WHERE parameter_type = ParameterType; I get error: "column "parametertype" does not exist"
I have table with data: create table measure_app_scalemeasurement ( store_code text, certificate_id text, audit_ending date); insert into measure_app_scalemeasurement values ('K010','vwv', '10.12.2023'), ('K010','cert1','12.12.2023'), ('K054','vwv', '14.12.2023'), ('K054','cert1','20.01.2024'); I want to select min audit_ending date for each market store_code, also getting its corresponding…
I have a table like: id login amount 22 *@mail.co 230 39 state}.com 340 I need to replace (escape) special characters of login column cells like in this JS method: strstr.replace(/[.*+?^${}()|[]\]/g, "\$&"). Using knexjs library with Postgres DB, I tried…
for this specific problem I had to enter the query: SELECT ProductName, Quantity FROM Products JOIN OrderDetails on OrderDetails.Productid= Products.Productid WHERE Quantity <5 On the website: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all The question that I got this query from from was "Can you modify…
I am using postgresql database. I have a table for requests: CREATE TABLE request ( request_id varchar(64) NOT NULL, company_id varchar(64) NOT NULL, department_id varchar(64) NOT NULL, created_time timestamp NULL DEFAULT CURRENT_TIMESTAMP, last_updated_time timestamp NULL, status varchar(10) NULL, retry_counter int4…
Example Tables: Table: TAB1 Col1 Col2 Col3 Col4 A1 A2 AA1 G1 A1 A2 AA1 G2 Table: TAB2 Col1 Col2 Col3 Col4 A1 A2 AA1 H1 A1 A2 AB1 H2 How to write a query to get Expected Result as:…
I have 3 tables and I want to have a query that gives me the sum of the sales, the sum of the deposits and the difference between them, try this but the records are duplicated. this is my query:…
Can someone please explain why this mysql query takes forever to execute? Its like it's stuck in a loop with no results returned. Screenshot SELECT m.title FROM movies m JOIN movie_starredin c ON m.ratingkey = c.movieid WHERE c.actorid IN (…
I am trying to call function that makes SQL call and returns the data to the calling function I am trying unsuccessfully to use async/await (promises) syntax in node.js/javascript My function is still behaving asynchronously. Perhaps not quite understanding how…
Snowflake table has a varchar column with following JSON array as value. [{"$":6394.2,"@":"decisionMetricValue","@id":"Month 1"},{"$":6672.25,"@":"decisionMetricValue","@id":"Month 2"},{"$":5643.05,"@":"decisionMetricValue","@id":"Month 3"},{"$":5564.79,"@":"decisionMetricValue","@id":"Month 4"},{"$":6966.75,"@":"decisionMetricValue","@id":"Month 5"},{"$":7605.15,"@":"decisionMetricValue","@id":"Month 6"}] Using snowflake sql, I would like to extract data in following format. Month1,Month2,Month3,Month4,Month5,Month6 6394.2,6672.25,5643.05,5564.79,6966.75,7605.15 I was trying to implement solution https://stackoverflow.com/a/77319223/20535715…