I am joining a few tables and in each join, I have to specify a specific condition. SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id WHERE table2.column1 = 'horse' INNER JOIN table3 ON table2.id = table3.id WHERE…
I don't know how to word the title properly, anyway what I mean is: For example I have this 'transaction' table SELECT ITEM_ID, SUM(QUANTITY) AS IN WHERE TYPE = IN GROUP BY ITEM_ID - SELECT ITEM_ID, SUM(QUANTITY) AS OUT WHERE…
I have a table with 30 columns. I want to remove all the rows in the table where a subset of columns have all the values in the row as either 0 or NULL. I know that I can write…
There are 2 tables : Sales & Transaction. I need to update the INDICATOR column of the Sales table using CASE WHEN by joining these two tables. Using below query but not working : Update Sales a set a.indicator= CASE…
how to convert the DateTime column to date? I need something like the select * from sales where date = = "2022-09-18"; I need to get all sales from a specific day I tried this How can I convert datetime…
I have a table with webpage data that looks somewhat like this: row_id ⁞ page_id ⁞ lang ⁞ title ⁞ slug ────────┼─────────┼──────┼────────────────────┼──────────────── 1 ⁞1 ⁞ en ⁞ Welcome! ⁞ begin 2 ⁞1 ⁞ fr ⁞ Bienvenue! ⁞ bienvenue 3 ⁞2…
Hope some of you pros can help me out on this sql / php issue. The short version: I need to add members to a task-database. So I have memberlist, it loop through each member and runs below sql. I…
I want to calculate percentage of value in Group by. My table data: id date artist track listenings 1 2023-01-01 C track_1 2016 2 2023-01-01 C track_2 3800 3 2023-01-01 B track_3 2311 4 2023-01-01 A track_4 4180 5 2023-01-01…
So I database for a university and I need to update several columns of a table named register going with the name of exam_grade, lab_grade, and final grade. The final grade is calculated based on the results of exam_grade and…
I have a SQL table that is filled with pending orders on day one. On the next day, at a specific time, I have to fetch the 'PENDING' orders from DB and process each of them by calling an external…