I am trying to figure out how to create a query/tsql that can import values from csv file to existing table. This is example how few records of csv looks like: And my existing table in SQL Employee table All columns already have values except SupervisorId (supervisorId is a foreign key that points at main key…
MySQL or MariaDB spread Date range in single row into multiple series of rows
Example tables are below, and example rows below, What I want to get is convert table above to below so that I can join using each date in range. Is there any way to extend date range in single row to series of Date row? Answer MariaDB 10.2+ or MySQL 8+ needed.
SQL query to filter columns
I have a question regarding the SQL query. I have this table shown below Region Rep Item Quebec Jones Pencil Ontario Kivell Binder Ontario Jardine Pencil Ontario Gill Pen Alberta Sorvino Pencil Quebec Jones Binder Ontario Andrews Pencil Ontario Jardine Pencil Alberta Thompson Pencil Quebec Jones Binder Ontari…
Gather the number of customer by street
I have two tables : Customer: id name address_id 1 John 4 2 Kate 5 3 Bob 2 4 Michael 2 5 Adriana 3 6 Ann 1 Address: id detail_str_name city district street_name 1 France,Paris,str.2,N5 Paris Paris str.2 2 France,Parise,str.2 ,N3 Paris Paris str.2 3 France, Lille ,str.3,N4 Lille Lille str.3 4 France,Paris,str.…
Using Join and Union to combine results from 2 tables [closed]
Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so it focuses on one problem only by editing this post. Closed 9 months ago. Improve this question I already have a result set using join from multiple master tables with T…
How to only run left join when the variable is not null?
I’m trying to simplify my stored procedure and I have one that is only using left join based on the user id that is passed in. If the user id is null, don’t do left join, but if it is null, left join it with another table. How should I re-write it ? Thank you Answer Currently your stored procedure
DISTINCT from One table and INNER JOIN with another table in snowflake
I would like to: Join two tables Remove “queryGroupName” = ‘DELETE’ from the first table From the first table, get Id by deduping (distinct ID) Using this Id, inner join with another table For output, select only the second table SELECT “TABLE2”.* FROM (SELECT DISTINCT R…
Filtering out objects from multiple arrays in a JSONB column
I have a JSON structure with two arrays saved in a JSONB column. A bit simplified it looks like this Schema: Since each row (data column) can be fairly large, I’m trying to filter out matching item objects and group objects from the items and groups arrays. My current query is this which returns rows co…
How to use DENSE_RANK and order by aditional column?
I am trying to use dense_rank to get element order for instance: I have table seq_test with data: after I run the code above, I’ve got : I want to achieve: So DENSE_RANK() function use its own order defined in function definition I need to order the SEQ column by sequence column. Update: I want to get: …
Transforming SQL Query to Django Expression
Assuming I have the following Django models and the according SQL-Tables with some data. I have simplified the models so that it is clearer. UserAnswer: id answer partquestion_id 1 667 1 PartQuestion: id question_id part_id 1 1 1 Solution: id content question_id 1 667 1 2 85 2 I want to get all User answers w…