I want to update two records from the age column in the table below, for this I use the following command: UPDATE `persons` SET `Age` =( CASE WHEN FirstName = 'User 2' THEN 10 WHEN FirstName = 'User 3' THEN…
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…
I have a bunch of device_id (roughly 300million), I want to create a full video resolution list ['360p', '480p', '540p', '720p', '1080p']for each device_id like device_id 1 2 device_id video_resolution 1 360p 1 480p 1 540p 1 720p 1 1080p…
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…
I consider a row duplicate when the combination of hash_key and load_date is repeating. I can find such rows using this CTE: with w_duplicated_rows as ( select hash_key, load_date, count(*), --row_number() over (partition by hash_key, load_date order by load_date desc)…
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…
I would like to sum my day to day values into full months values This is the current table: Date Value 2024-01-01 12 2024-01-02 10 2024-01-03 20 2024-01-04 5 2024-02-01 15 2024-02-02 20 2024-02-03 10 I would like to create…