I'm trying to order columns by empty string last. For example. NAME -------------------------- Apple '' Orange Avocado Banana Cauliflower Broccoli '' Potato Cabbage The order should be like this without alphabetical order NAME -------------------------- Apple Orange Avocado Banana Cauliflower Broccoli…
Query 1: WITH cte AS ( SELECT *, MAX(score) OVER (PARTITION BY exam_id) AS max_score, MIN(score) OVER (PARTITION BY exam_id) AS min_score FROM student JOIN exam USING (student_id) ORDER BY exam_id, student_id ) SELECT * FROM cte; By Query 1,…
I have this join: SELECT * FROM persons p LEFT JOIN orders o ON p.id = o.person_id LEFT JOIN old_orders oo ON p.id = oo.person_id LIMIT 100 orders and old_orders have exactly the same structure and for misc reasons they…
I have a docker container running cytopia/mysql-5.7, looking back (a long time ago) the command I used to create this image was docker run -i -p 127.0.0.1:3306:3306 -e MYSQL_ROOT_PASSWORD=foobar -t cytopia/mysql-5.7 Clearly here I haven't defined a volume or to…
I have a SQL query result I would love to clean up, the query result is following NAME OPT_IN JOHN TRUE JOHN FALSE KEK TRUE and now I want to select | JOHN | FALSE | when | JOHN |…
I am trying to count the number of days between two dates that are present in the same column! when the ID is are same. Here is a sample below... ID Date a 01/12/2024 a 01/13/2024 b 01/12/2024 b 01/20/2024…
I have a mysql table as: A B C D E F 12 23 15 17 9 21 9 13 15 19 4 2 26 11 6 3 15 21 I want to add a new column, where the value…
Im wondering what the best practice is for my table layouts to be for a many to many realtionship. To set the scene we have 2 tables. A table of people, and a table of locations defined as follows CREATE…
I'm trying to search the entire row of my database for the user's searchbar input. The code I have returns an empty set: $posts = Post::where([ ['title', 'LIKE', '%'.$search.'%'], ['description', 'LIKE', '%'.$search.'%'], ['intro', 'LIKE', '%'.$search.'%'], ['row_1_heading', 'LIKE', '%'.$search.'%'], ['row_1_body', 'LIKE',…
I want to select all columns from table A and just one column from table B, the information is related so I tried to join tables, but didn't work. The following setup can be used as example, note that genreId…