Thanks in advance. I’m basically trying to run a SQL query so that the results are 1:1:1:1:Many for StaffID:Name:Floor:Date:Shifts. Here is my initial query and example results: I then combined the ShiftStart and ShiftEnd columns with the following to get the further below results: What I can’t fi…
Tag: distinct-values
Calculate distinct values per day that resets each month (Big Query)
If I have table like this that contains unique id of a store and the date when they make an order store_id order_date A 01-Jun-21 A 02-Jun-21 B 02-Jun-21 C 02-Jun-21 A 03-Jun-21 A 04-Jun-21 D 04-Jun-21 A 01-Jul-21 B 01-Jul-21 I need to aggregate it by day, but each day should only consist of store_id that nev…
Add ‘iteration number’ column to SQL Select based on same values from two columns
I have a SQL (SQL Server) statement SELECT id, animalId, ownerId FROM myTable ORDER BY id which outputs the following data: id | animalId | ownerId ———————— 1 | 123 | 62 2 | …
count number of times a value appears in a column not GROUP BY in SQL
Let us assume one has the following table (without the CountX column) : I would like to add the column ‘CountX’ with the number of different entries, per each combination of Name & City. I tried to use ROW_NUMBER() but it does not work well: I also tried to do a sub-query, using select distinc…
SQL: Retrieve Distinct for different columns
I have the following scenario: In a SQL-Table I have the following columns: |—————————————-|————————————-| | Col 1 |…