Given the following table1 schema: +---------+-----------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------+-----------------+------+-----+---------+----------------+ | ID | int | NO | PRI | NULL | auto_increment | | NAME | bigint unsigned | NO…
Consider the table ID Value 1 3 2 4 3 6 4 7 5 8 6 11 7 12 I want to find rows where the difference between two subsequent Values is different than 1. Id = 2 has Value…
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 (…