I have I have a column address with the string like this: Tow 10 Floor 223, Ward AA BB, District CC DD, City E F and Tow 110 Floor 23, Ward BB AA, District DD CC, City F E ...…
I make a dropdown for a form, I will show the code below. However, when I click the submit button, there is an error saying, SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'brand' cannot be null (SQL: insert into supplier_details. The…
I have 3 table with excatcly same columns names. For this example lets say id,name,category, price. when i extract data i got the desired data where each field renamed to source table. it is not so convinet and i want…
i have developed a pgplsql function to receive array of dates the return the maximum date, but its not able to call the function: select 1, arcfm.array_max_date('{2022-02-03, 2022-06-05}'::timestamp[]) as max_date_time; CREATE OR REPLACE FUNCTION arcfm.array_max_date(in dates_array timestamp[]) RETURNS timestamp LANGUAGE…
I have a database with multiple tables, and I want to add a column to one table that will be populated with different strings based on the contents of another table. Below are the tables of interest. CREATE TABLE Locations(…
I have this db table: http://sqlfiddle.com/#!9/e1dd38e/7 I am trying to query it so it goes thru each category, returning each subcategory's top 3 vendor's, ordered by their total of spend (sum(amount)), the vendors outside of the top 3 will be…
I have a table: client_id Date Resolution 1 2022-10-15 CANCELLED 2 2022-10-25 CANCELLED 3 2022-10-16 CANCELLED 3 2022-10-17 REJECTED 4 2022-10-08 CANCELLED 4 2022-10-20 APPROVED 5 2022-10-03 CANCELLED 5 2022-10-04 APPROVED Desired results: client_id 1 2 4 I need to…
I have a table named Users, with userId as one of the column, the user can be in any one of given 5 possible states which are (Unregistered, registered, subscribed, premier, unsubscribed). I want a query which can give me…
I am trying to update multiple values at the same time, Table values UniqueRef, Name 1101, AA01 1102, AA02 1103, AA03 I want to update UniqueRef for all of 1101, 1102 and 1103 to different values e.g 1101 will be…
In my table, I have a 'start_date' and 'end_date' column, eg: start_date end_date 2000/12/12 2010/10/12 1988/12/12 2003/04/03 1994/12/12 2008/09/21 What is the statement that I need to use to extract the years between the start & end date? I want…