I have the following tables: customers table: name email saqib [email protected] scott [email protected] amy [email protected] account_description table: account_type description 13 personal 14 corporate Is there way to re-write the following query without CTE or subquery? with cte_customers as ( select…
I am working on a Laravel app that needs to do a groupBy on a set of items like groupBy does on a collection however doing this on collection after getting the data will not work as I need to…
I'm new to SQL, I'm learning from a free youtube MySQL course for beginners. 2 days ago I gave myself a problem and now I found a work-around, but perhaps there are better ways to solve it. emp_id super_id 100…
I am trying to get the category of specific students health inspection for each month. However, sometimes there are multiple entries for a month. How do I get the latest entry for the month using SQL? Below is the SQL…
I expected an error to occur with the following query, but instead, the query is executed in an unintended direction. Copy code SELECT MAX(A) FROM table_a; >> 1 SELECT A FROM (SELECT MAX(A) FROM table_a) AS TMP; >> ERROR SELECT…
I'm encountering an issue with the SQL COUNT function that I need assistance with. Here's the scenario: In my database, I have two records with values '-try' and '-try2.' However, when I use the COUNT function in my SQL query,…
In PostgreSQL, I am attempting to fetch the previous Thursday and the previous Wednesday based on a thursday date (for example 2024-01-18). I have tried the following queries: For the previous Thursday: SELECT date_trunc('week', '2024-01-18'::date) - INTERVAL '5 days' AS…
How do we query for a particular fields in an array element inside a json string The column datatype is JSONB Sample json { "data" : [ { "begin" : "..." }, { "inter" : "..." }, { "inter" :…
I have the following sql code for MariaDB and it is working, but now I try to rewrite it into to sql for PostgreSQL and get an error. The sql code for MariaDb is: SELECT monthname(f.datetime) AS month, sum(case when…
I have a function returning jsonb records SELECT get_my_records( 'some', 'args' ); { "a": 1, "b": 3.14 } { "a": 2, "b": 2.71 } ... and trying to use jsonb_to_record() to convert the records to a | b --+----- 1…