I am trying to make a simple SQL query in PostgreSQL to use in our team: with findData as ( select '(''XXX'',''YYYY'')' as dataList ) select * from findData That gives the result: ('XXX','YYYY') Exactly what I wanted ! But…
From DBeaver Community, I access my database and create a new SQL query. I write the corresponding code for the CTE I want to create, but it constantly shows a syntax error. I've tried everything, but I can't find the…
I have the following snippet of a table that I am trying to filter some identities for: id fid ts val 44292 1243 2014-12-15 00:00:00.000 True 44292 1243 2017-02-02 00:00:00.000 False 44292 1250 2014-12-16 00:00:00.000 ABC 44293 1243 2014-12-15 00:00:00.000…
I get the following error when executing an sql query and can’t figure out what I’m doing wrong, please help me. The purpose of the query is to calculate the median cost of orders for all tables - even Text…
I have a table where I want to find the average value of column1 and column2, but in some cases there may be null values in either columns. In that case, I just want to be shown the value that…
I have table as follows (let's call it old data). UNIQUE_PJT PROJECT JOB_TITLE SALARY_A SALARY_B IT_9810_PR IT_9810 Programmer 10000 6000 IT_9810_AC IT_9810 Accountant 9000 4500 IT_9810_SPR IT_9810 Programmer Sr 15000 8000 IT_9810_SR IT_9810 Sales Representative 12000 9000 This data extends…
Given the following scheme and values I want to compute the value of each row starting by adding 1 to the previous row value. If the row value is null then set null. If there is a value then add…
I want to drop unused tables. I listed empty tables to make sure that tables not getting inserts and deletes (using such as temporary table) within 1 week. Is there way for checking if a table is not getting any…
I'm using Postgres. Suppose I have only one record that satisfies the query parameters. My friend claims that I can speed up query completion if I use limit=1; This is true? GPT Chat also states that the database will stop…
I'm building a stored procedure that returns the lowest price of each product and show their respective store info and date. This SP should allow optional parameters for StoreCity and ProdType. I'm a bit stuck on the SELECT query. These…