Aggregating table to json combined with references to other tables – Postgresql
Table A: id status 1 1 2 4 Table B: id status a_id 1 1 1 2 3 1 3 5 2 Table A ( id int, status int); Table B( id int, status int, a_id int foreignt key reference…
Dynamically pivotting table – Mysql
Under spu_pricebucket there are 5 different pricebuckets. I want to change it so each pricebucket will have its unitprice below it. End goal is to turn this table from 6 columns and 10 rows to 9 columns and 2 rows,…
How to use a MySQL case statement in a window frame to calculate running total of a column?
I have two columns date and sales and the objective is to use case statement to create another column that shows the cumulative sum of sales for each date. Here's the sales table date sales 2019-04-01 50 2019-04-02 100 2019-04-03…
How can I do an update with case and select? – Mysql
I'm trying to assign an ID code by searching for the name. update db.request r set s.CreateByID = ( select r.ID from db.user u where r.NameCreateBy = u.Name ) where r.ID in (23506); How would I put a case clause…
Not getting an error when select a column that is not an aggregate function nor in the group by clause – Mysql
Here is the problem from leetcode: Table: Users +---------------+---------+ | Column Name | Type | +---------------+---------+ | id | int | | name | varchar | +---------------+---------+ id is the primary key for this table. name is the name of…
I want all retrieve all data of customer within a radius with longtude and latitude of 1 km – Mysql
I'm using redash and my table looks something like this. I'm just learning sql. This is very advanced for me. I searched many questions, no queries worked for me |user_id | long | lat | |1 |31.000|26.000| |2 |30.000|25,000| |3…
SQL: how to select where one column does not match another column for ALL records within a given group – Mysql
I have a table named sales in a MySQL database that looks like this: company manufactured shipped Mercedes Germany United States Mercedes Germany Germany Mercedes Germany United States Toyota Japan Canada Toyota Japan England Audi Germany United States Audi Germany…
SQL Case – how to order by another field ASC – Mysql
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…
How to rewrite a query without a subquery – Postgresql
I have this query: select qt.id as id, ev.id as event_id, res.allocation_date as date from quota qt left join result res on qt.id=res.quota_fk and (res.allocation_date=(select max(res2.allocation_date) from result res2 where res2.quota_fk=qt.id)) left join event ev on qt.id=ev.quota_fk this query correctly…
What does this part of my SQL query mean? – Postgresql
sum( (record_id is NULL AND joined.table_id is NULL)::int ) I know the sum returns the sum of the column entries, but what will this expression (... and...) return, can it be compared with this expression (.. + ..), and what…