Trying to select earliest order_date for each customer_id. Using following query SELECT customer_id, order_date FROM Delivery GROUP BY customer_id HAVING MIN(order_date) = order_date But those customer_id with more than one order_date rows are not showing in the result. For example…
I have one table and data in it. Below is the table +----+-------+------+---------+-------------+-----------+ | Id | p_name| grade| promoted| created_on | review_by | +----+-------+------+---------+-------------+-----------+ | 1 | Abc | A | Yes | 2023-Jun-14 | AK | | 1 |…
I'm learning SQL from a website. The question they asked was Show the provinces that has more patients identified as 'M' than 'F'. Must only show full province_name Table My attempted answer using subqueries, rather than join (I am trying…
I have below PostgreSQL table, which is small sample of huge table employee emp_id | salary | rating | increment_year -------------------------------------- 28 3000 1 2023 25 2000 2 2023 30 1500 1 2021 28 1000 3 2022 32 1200 1…
laravel query with fetch data I have below table in "ORDCOMPLETE" is duplicate with same order ID #11310, so I need to remove this duplicate id with the same prefix. #11309 ORDCOMPLETE7104671693208650 $30 #11310 ORDCOMPLETE4335631693207733 $30 #11310 ORDCOMPLETE4335631693207744 $30 #11310…
I have following SQL (PostgreSQL) query: DO $$ BEGIN IF EXISTS (SELECT * FROM segment WHERE slug = $1 AND is_active = true) THEN RAISE EXCEPTION $2; ELSE INSERT INTO segment (slug) VALUES ($1) ON CONFLICT(slug) DO UPDATE SET is_active…
I have a JSON data like this: {"payload":"{"custom":{"a":{"hs.dl":"hs:\/\/categories\/Z2lkOi8vc2hvcGlmeS9NZW51SXRlbS81NDM2Nzk0NDczODI=","hs.image":"https:\/\/cms-highstreetapp.imgix.net\/denham\/2023\/08\/0657f839-0045-49b0-ba89-fbde3c74f519\/montage20230818-1-kzy7bm.jpg","hs.body":"Reworked in the colours of the season.","hs.video_720":null,"hs.thumbnail":"https:\/\/cms-highstreetapp.imgix.net\/denham\/2023\/08\/0657f839-0045-49b0-ba89-fbde3c74f519\/montage20230818-1-kzy7bm.jpg","hs.title":"Free Move Chinos","hs.video_480":null,"hs.id":"HS_STUDIO-91428"},"i":"31d443e3-1874-4deb-b475-ac10c850451d"},"aps":{"mutable-content":1,"alert":"Free Move Chinos - Reworked in the colours of the season.","category":"category","sound":"default"}}"} Currently, I am replacing escaping characters this way: REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(value, 'hs.', ''), '\"', '"'), '"{',…
I have something like the table below that is incredibly large. Where the "Category" column is Null, I need to return the Category based on the rows where category is NOT null. The logic should be that IF the Category…
I have a transactional database with more than 100 columns. Now if I have to select all the rows but only those columns which have changed down the table (more than one distinct value for a particular column). how can…
There are multiple historical rows present for a customer in customer table and a id has been assigned which might have changed overtime Name ID Date Abhishek 1 23-08-2023 Abhishek 1 03-08-2023 Abhishek 2 17-06-2023 Abhishek 3 09-10-2022 Seema A…