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 *,…
I am having a table marks, I need to print the details of names having continuously increasing marks. Table : Marks Name Sem Marks A 1 80 A 2 90 A 3 95 B 1 80 B 2 70 B…
I need some SQL help. I have a table where I'm trying to get the % split between online sales and POS sales. Below is the query I have written and the screenshot is what I get, but I don't…
In a one-to-many relationship, users have many contracts. However, I only want the most recent contract for a specific set of users. My query to get all contracts for users look like this: SELECT userid FROM contract WHERE userid IN…
I have the following table with one row. I have tried to query this table to return authors under the age of 40 and have been unable to do so. CREATE TABLE bookstuff ( data JSON ); insert into bookstuff(data)…