How can I use the value from one query into the second one. I tried with an alias "papa" but I read that the order of executions makes the alias not available to the second query. What would be the…
I have a table like this CREATE TABLE userinteractions ( userid bigint, dobyr int, -- lots more fields that are not relevant to the question ); My problem is that some of the data is polluted with multiple dobyr values…
How to let the query result be ordered by the exact order of passed items in the WHERE clause? For example, using this query: SELECT id, name FROM my_table WHERE id in (1,3,5,2,4,6) ORDER BY id Result: id | name…
I want to delete duplicates from a Redshift table that are true duplicates. Below is an example of two rows that are true duplicates. Since it is Redshift, there are no primary keys to the table. Any help is appreciated.…
I have join table between t_table and s_table. there are many to many relationships between them. s_table id s_value 1 1 2 2 3 3 t_table id t_value 1 100 2 200 3 300 t_id_s_id_table s_id t_id 1 1 1…
I want to get the rownumber of each row from a MySQL Table. I already read this article and tried the suggested select statement as below, SELECT @rownum:=@rownum + 1 as row_number, t.* FROM ( select * from myTable )…
Hi stackoverflow I have here a sql statement that is pretty slow performing which I think is due to the subquery seen in the sql below. My question is simply given that this subquery and the fact that it must…
I have a data source with a bunch of time stamps. I want to find the week start (sunday) date from these time stamps. Eg, I want to go from "2022-11-23 00:00:00.0" --> "2022-11-20" for every date in the column…
I am trying to create a database use mysql workbench and I keep getting this error and my code looks fine. Not sure how I can resolve this. This is the error I am getting: Error Code: 1049. Unknown database…
My problem is that I have a table with data like this - ID COLORS -------------------------------------------- 1 ["red", "green"] 2 ["blue", "red"] 3 ["red", "green", "yellow", "blue"] What SQL witchcraft will I need to wield in order to create a…