I need to display SQL query results by having specified columns appear first (on the leftmost side of the table). The currrent code I have is: Select * from table order by column 4, column 3, column 1 Result: column…
SELECT f.user_id, f.item_id, f.status, f.shipped, CASE WHEN f.status = 0 THEN UPDATE f SET f.status = 1 WHERE f.user_id = 1 AND f.item_id = 1 WHEN f.status = 1 THEN UPDATE f SET f.status = 0 WHERE f.user_id = 1…
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 want to retrieve all buy orders with a count of matching buy orders in a single query. A match would be a sell order that satisfies all attributes (greater or equal) and is cheaper than the buy order. Is…
When a post is accessed, I need, in addition to returning the information of this posts, to return the previous one if it exists and the next one. I would like to know if there is a way to select…
I have a MySQL database table that looks like below: +----------+------------+---------------------+ | name | event | created | +----------+------------+---------------------+ | Player1 | Logged in | 2023-02-14 10:05:00 | | Player2 | Logged in | 2023-02-14 10:05:30 | | Player3 |…
I have the table contacts which contains duplicate records: id name is_contacted created_at I need to delete duplicates, but keep the first record(among the duplicates for each name) where is_contacted=1. If among the record duplicates there are no records where…
I am looking to essentially create a pivot view using PostgreSQL, such that the table below: Column A Column B Happy Sad Sad Happy Happy Sad becomes Count Column A Column B Happy 2 1 Sad 1 2 I've been…
I have a table with medication_product_amount column where there are spaces between numbers and characteres like below: medication_product_amount 1 UN DE 50 ML 20 UN 1 UN DE 600 G What I want is to remove the single space ONLY…
I am attempting to find percentage change per each month per company. Table Year Mon company_id Revenue 2018 2018-06-01 42 2000 2018 2018-07-01 42 3000 2019 2019-06-01 42 4000 2019 2019-07-01 42 9000 I attempted this and failed. select *,…