I'm trying to figure out how exactly ON and WHERE work when doing a JOIN My understanding based on other questions is that I should filter in where when the condition is on the left side of the join, and…
I have a table and it has a column start_date. I have two variable fields/filters from_date and to_date on which I want my records to be filtered. I am working on a SQL/PostgreSQL/pgAdmin4 script that returns all the rows whose…
I have the following table: create table table1 ( id serial, workdate date, col1 varchar, col2 varchar, col3 varchar ); And I have inserted the following data: insert into table1(id, workdate) values (DEFAULT, '01/12/2023'); Now I updated it, looking to…
Let's suppose we have two queries (I use postgresSQL with psycopg2): 1 - query= """ SELECT * FROM same_table """ 2 - query= """ SELECT * FROM same_table WHERE id = %(some_id)s """ Is it possible to crate a single…
We have this query that is running: SELECT concat_ws(' ', z.ticker, CASE WHEN a.date_approved IS NOT NULL THEN TO_CHAR(a.date_approved,'YYMMDD') WHEN z.date_recommended IS NULL THEN '000000' ELSE TO_CHAR(z.date_recommended,'YYMMDD') END, CASE WHEN s.ticker IS NOT NULL THEN 6 WHEN a.approved_recommendation IS NOT…
I'm trying to create a search function on my website which searches for keywords in a number of columns in my main table, and also any tags which match those keywords linked via an associative table. I've got a query…
i want to select 5 lastest data by date (month) including data that does not exist in codeigniter heres salesdata table (every date fixed by 1) id date stock sold a1 01-01-2024 2 28 a1 01-08-2024 12 100 a1 01-04-2024…
Noob question, but I cannot find answer anywhere. I want to pre-populate my database with some values, which refer to each other via foreign keys. But I see no way to do that without explicitly using IDs, which are supposed…
I have a table with 3 columns like this: +---------+--------+-------+ | Country | Number | State | +---------+--------+-------+ | Canada | 12 | 0 | +---------+--------+-------+ | Canada | 14 | 0 | +---------+--------+-------+ | USA | 10 | 2…
Taking into account the following example tables: USERS: id_user name 1 Paul 2 Caroline TRAVEL: id_travel id_user 1 1 2 1 3 2 TRAVEL_DAYS: id_tdays id_travel day_has_activities 1 1 no 2 1 no 3 1 yes 4 2 no 5…