I am trying to get distinct values from each column and not distinct row values. My Query is: SELECT DISTINCT ac.admin_id , sc.student_id , tc.teacher_id from contact c join admin_contacts ac on ac.`contact_id` = c.id join student_contacts sc on sc.`contact_id`=…
I have a table structure as follows: Shops Table: id shop_name 1 My Shop 2 Another Shop 3 Final Shop Orders Table: shop_id order_id data created_at 1 123 json 01/01/2023 2 456 json 01/01/2023 3 234 json 02/02/2023 1 765…
I have Attendance table: EmpId DateEntry AttType E-0001 2024-01-01 08:00:02 IN E-0001 2024-01-01 17:01:00 OUT E-0002 2024-01-01 07:59:02 IN E-0002 2024-01-01 17:00:07 OUT How to query this table into: DateEntry EmpID ClockIn ClockOut 2024-01-01 E-0001 08:00:02 17:01:00 2024-01-01 E-0002 07:59:02…
So i want to have it so that i have 6 columns. But the 6th is for orders. The way i see it is VNr is connected to vare and ordrelinje. And thats where OrdreNr comes in which is number…
NULL is being returned from STR_TO_DATE function when using the week number format directive (%U, %u, %V or %v) on MySQL 8.0.35. The official documentation indicates that STR_TO_DATE should be the inverse of DATE_FORMAT. I expected to get the same/similar…
Using Filament PHP, i'm facing a problem with a relation, I can access the resource create view, and save the content (with all the relations fine), but the error appear when I open the edit view of the resource. I…
I have a simple table, but want to add a code so i can put a special result in a chosen position. SELECT * FROM table ORDER BY rating DESC LIMIT 10; I also have a column called position. If…
Here is how the code looks like. "vare" is the section i want to update def update(): sqlCon = pymysql.connect(host = "localhost", user = "root", password = "root", database = "varehusdb") cur =sqlCon.cursor() cur.execute("update vare set Betegnelse=%s, Pris=%s, KatNr=%s, Antall=%s,…
https://www.hackerrank.com/challenges/contest-leaderboard/problem?isFullScreen=true The total score of a hacker is the sum of their maximum scores for all of the challenges. Write a query to print the hacker_id, name, and total score of the hackers ordered by the descending score. If more…
I have table Att_Log like this: Emp_ID Date_Att Time_Att E-0123 2024-01-02 08:05:56 E-0123 2024-01-02 17:02:23 E-0124 2024-01-02 21:55:56 E-0124 2024-01-03 06:02:23 the results I expect is like this: Emp_ID Date In_Time Out_Time E-0123 2024-01-02 08:05:56 17:02:23 E-0124 2024-01-02 21:55:56 06:02:23…