I'm trying to update a table in MySQL 8.0.35, but it seems like it doesn't like the way I'm formatting this query. I can insert into tables this way, but I get an error when I try to use it…
I have two tables, master and Details, and I need to generate a report that counts the occurrences of each status value for each remark. Here's the structure of my tables: Table: master m_id (Primary Key) remarks (TEXT) Table: Details…
I'm working on a monitoring system based on MySQL. The system consists of a table which records checks (e.g. a crawled website) for multiple users. The users shall be notified about their last failed (NOK) check but only once a…
I have a query writing problem. My table: -> table users_keyword_document document_id | users_keyword_id -------------+------------------ 65 | 1 65 | 2 66 | 1 66 | 3 I want to retrieve only the document with document_id 65 The search can…
Imagine you have the following table named city: market product cost A 1 54 A 2 62 A 3 38 B 1 12 B 2 12 B 3 5 I need the most expensive product for each market, i.e.: market…
I was testing the query below thinking it would get me around the "can't use LIMIT in subqueries" restriction. The query runs but the average is simply the average of all the records WHERE MScores.MemberId=1193 AND MScores.Div="FSO" It seems to…
I want find Students id that , must have (professorId = 3 And courseId = 4) And (professorId = 3 And courseId = 2) And (professorId = 5 And courseId = 8). sometime these parenthesis is one or more than…
I have a query like select C.customerId, C.firstName, C.LastName, R.IsActive from Customer as C Inner join Rider as R ON R.customerId = C.customerid where R.rideid = 'xyz' and R.rideareacode = 'abc' and R.isActive = 1 This is taking too much…
I have a site that has multiple courses and each course has multiple lessons. I would like to select the highest score per LESSON for a given user_id and course_id ordered by lesson_order. TABLE lesson id course_id lesson_order ---|-----------|-------------- 1…
I am Working on project, where I am using two queries to get the result i wanted to process. Query 1 SELECT MID FROM PMS.MACHINE WHERE STATUS=1 AND MID !=0; Query 2 SELECT MID,COUNT(STATUS) AS QUEUE FROM PMS.QUEUE WHERE STATUS=0…