I wanted to do a condition wherein I put values (000000) in DATE_COMPLETED if it see's the FLAG_CLOSED = Y and if its not Y then do nothing SELECT "JOB", "SUFFIX", "SUFFIX", "DATE_COMPLETED", "FLAG_CLOSED", CASE "DATE_COMPLETED" WHEN "FLAG_CLOSED"='Y' THEN "DATE_COMPLETED"='000000'…
I have a long and wide list, the following table is just an example. Table structure might look a bit horrible using SQL, but I was wondering whether there's a way to extract IDs' price using CASE expression without typing…
I have a table called country that has 2 columns: orderid, country_code. I need to do the following CASE WHEN: SELECT CASE WHEN country_code IN ('PT','IT','ES','PL','AD') THEN 'SWE' WHEN country_code IN ('MD','BG','BA','SI','HR','ME','RO','RS') THEN 'SEE' WHEN country_code IN ('CI','GH','MA','NG','UG','KE','TN') THEN 'AFRICA'…
I have a SQL query that sorts a table for a local restaurant into categories, but after that I would like to sort alphabetically by title. The end result should sort the categories, and then the content is sorted alphabetically…
so I have this left join LEFT JOIN LATERAL (SELECT d.country FROM db.patient_info d WHERE d.id IN (SELECT DISTINCT st.category FROM db.surgery_types st, db.surgery_record sr WHERE sr.id = st.surgery_record_id AND sr.surgery_type_id = m.id) ORDER BY d.priority, d.country LIMIT 1 )…
I have a quick question in relation to windowing in MySQL SELECT Client, User, Date, Flag, lag(Date) over (partition by Client,User order by Date asc) as last_date, lag(Flag) over (partition by Client,User order by Date asc) as last_flag, case when…
The below query is part of a select query which I have got in my application where case when o.tracking_id <> '0' then a.account_id is null and o.status = 'N' else ( o.tracking_id = '0' and o.status = 'N' )…
So I essentially want to work around the fact that CASE WHEN stops executing when it finds its first TRUE return. I'd like to sum every instance of a non-null value between multiple columns, and group these based on my…
Hi all, I have a table as shown in the screenshot above. I wrote a query using CASE statement so that it will return extra columns that I need. Below is the query that I wrote: SELECT *, CASE WHEN…
I receive a syntax error for the following: CREATE OR REPLACE FUNCTION my_function(old_num INTEGER) returns INTEGER language plpgsql AS $$ DECLARE new_num INTEGER; BEGIN CASE WHEN (old_num IN (1, 2, 3, 4)) THEN new_num = 10 WHEN (old_num IN (5,…