I'm having problems with the case statement in PostgreSQL. Here I want to change the output of the month (number) to text, like January, February, etc. select date_part('month', tanggal) bulan, case when date_part('month', tanggal)= 1 then 'January' when date_part('month', tanggal)…
I have a simple function triggered on any updates to a PostgreSQL 14 table: CREATE OR REPLACE FUNCTION track_changes() RETURNS TRIGGER AS $body$ BEGIN raise notice 'old is: "%"', OLD; raise notice 'new is: "%"', NEW; END; $body$ LANGUAGE plpgsql…
I have an sql table in phpmyadmin db which has 8 columns. I want to check if 4 of them (specific 4 columns) equals to some value. For the example, lets say the value is "abcd", and the columns names…
Suppose I have clients and services of the following schema: create table client ( id INT NOT NULL, name varchar(100) NOT NULL, PRIMARY KEY ( id ) ); create table service ( id INT NOT NULL, client_id INT NOT NULL,…
There is a hospital database that has the following schema for admissions table: patient_id INT admission_date DATE discharge_date DATE diagnosis TEXT room_id INT doctor_id INT insurance_id INT here's what I am trying to query: fetch the total amount of admissions…
I am doing an API call which returns the following JSON as a string: [{ "id": 103000180455, "name": "Personal", "created_at": "2023-06-12T07:12:52Z", "updated_at": "2023-06-12T07:12:52Z", "personal": true, "responses_count": 1 }, { "id": 103000180454, "name": "General", "created_at": "2023-06-12T07:12:52Z", "updated_at": "2023-06-12T07:12:52Z", "personal": false, "responses_count":…
I am new in data base phpmyadmin Here my query that is giving error ALTER TABLE students ADD CONSTRAINT fk_enrollment_student FOREIGN KEY (student_id) REFERENCES enrollments (student_id); Here are structure of my table Table: students Table: enrollments Table: courses It is…
SELECT COUNT(wo.id), wm.* FROM webshop_orders as wo LEFT JOIN webshop_merchants as wm ON wo.merchant_id = wm.id LEFT JOIN webshop_merchant_order mo ON mo.merchant_id = wm.id AND mo.language_id = 1 WHERE (mo.hidden = 0) AND wm.status = 1 AND DATE(wo.created_at) > CURDATE()…
I have one table like below query mysql> select *from DemoTable; This will produce the following output − +--------------------+ | ListOfValues | +--------------------+ | 20, 10, 40, 50, 60 | +--------------------+ 1 row in set (0.00 sec) Expected output is…
I Have one table i.e discount_details. I have 2 columns are the ID , DiscountTotal. I want to sum the each record line total json object with in the D array (64,10,10 are the 1st record values) . Like here…