Remove second “Day” column and Turn nulls to 0
I have the following query in MySQL:
Cascading rolling total logic in SQL
I am trying to recreate the cascading sum logic of our Student Information System (SIS) to build a tracking report that will aggregate all graduation requirements in one place.
Select rows based on condition for decimal columns returns nothing
I have the following table:
Wrong comparing double column to string in MySQL [duplicate]
This question already has answers here: mysql query compare string with int value (3 answers) Closed 17 days ago. SELECT t.id, t.status, t.charges FROM parcel AS t WHERE t.user_id = 1 AND t.status = ‘delivered’ AND t.charges = ‘some string’ ORDER BY t.id DESC i have this mysql query. it returns some result, but it […]
Get Records between dates and exist at least 3 times
I have table with over 35 million email records.
The used SELECT statements have a different number of columns (SQL ) BUT WHY [closed]
Closed 2 days ago.
A hackerrank sql challenge
This exercise gived 5 table:
MySQL Query performance – best partial match
I have performance issue on a query, potentiall wrongly written.
Multiple table date constraint
I have 2 tables.
Multiple table date constraint
I have 2 tables.