I am getting following error while executing my mysql query via a .sql script, but couldn’t tell what is causing this error. I am using mysql Ver 8.0.23 for macos10.15 on x86_64 (MySQL Community …
Tag: sql
Split string without string_split (Sever 2012) [closed]
I would like to know if and if it’s possible how to split a string in to different columns. So first of all I have the table tabOld which contains: name 5522-rep__-4210-03-test-434907-emn-nt.pdf …
SQL, how to group rows based on field values
i have question about query result group. The image is a example. it is cable list. Each cable come with two attributes, ‘From’ location and ‘To’ location. if we’d like to group the cable list by …
How can I count the amount of items per user?
What I need to do is to Count the Times a User has received the treatment ‘Oxygen’. I’m trying to do like below but I’m getting all of the entries from Treatment_Victim per user. Any help is well …
How to get the most liked users on a particular date in django
So I have a social media app, where users can like the posts of other users. Now I fetch the top 20 users who have received the most number of likes. Everything is perfect. But the problem is I cant …
Group by Count of DateTime Per Hour by removing Duplicates?
I have a table named loginData: userName timestamp abc ‘2007-01-01 12:00:12 AM’ def ‘2021-01-01 12:09:12 AM’ abc ‘2021-01-01 12:40:12 AM’ abcde ‘2021-01-01 12:44:12 AM’ From this …
Create calculated field from MIN() and MAX() values of another column, grouped by unique ID
I have a table that looks like this, containing information about an object’s position and the length of time it existed for (age): Date ID Age x y 2021-03-25 20 1 531 295 2021-03-25 20 …
How to copy information in SQL from one table to another
I need to build a query to copy information in a column from one table to a column in another table. This is how the tables looks like: People: PersonId Name StatusId 1 John 2 Jenny 3 Steve …
Limit the results returned by MySQL join to 1
I’m doing a JOIN on two tables and the right side has multiple results for the ON clause: e.ID = ti.event_id. How do I limit the results returned by the join to 1? Sort of like LIMIT 1 events_detail …
Join pandas dataframes based on different conditions
I´m using Pandas in Python and I’d like to join 2 dataframes. My first dataframe is: id var date 1 ABCD 2019-01-01 1 ABCD 2017-06-01 1 ABCD 2016-06-01 2 ABCD 2016-01-01 The dataframe I want to …