Given the following two relational schemas, the EMPLOYEE relational schema records the employee number (ssn), age (age) and the department (dno), the primary key is ssn, and the DEPARTMENT relational schema records the department number (dnum ) and name (dname),…
I have two suppliers where I am trying to filter the products to achieve the following: Select Products from Table1(supplier 1) that are not already present in Table3 and some further filtering on categories (Working) Select Products from Table2 (Supplier…
I have a posts table with a JSON column of an array with IDs. This column's data looks exactly like: [1, 3, 17, 19] These values are not quoted. To check if a user should see a post, I simply…
I'm trying to validate my checkbox from a loop, where at least one is checked and displays an error/alert or disable the submit button instead if there is no checkbox checked. I tried putting a required method inside my checkbox,…
Simplified the following question I got from a coding challenge... I have a table grades like: year sex person mark 2000 M Mark 70 2010 F Alyssa 23 2020 M Robert 54 I want to select the people per year…
I think I may be onto something. But I'm still having a problem. What am I missing here to define the Task1?. Some info you may need is I am using MySqli PDO. $sql = "INSERT INTO Tasks (FirstName, LastName,…
For example 'ABC-12345-6789-10' I want to return "10" as these are all the characters after the last "-" dash. I have tried this but I only get a zero at the end: SUBSTRING('ABC-12345-6789-10',len('ABC-12345-6789-10'),LEN(CHARINDEX('-', 'ABC-12345-6789-10')))
Question: SQL query to best get the desired result below. Input: Identifier Date 1234 2022-01-01 1234 2022-08-11 7890 2022-08-11 4444 2022-08-13 Output: Identifier Date 7890 2022-08-11 4444 2022-08-13 Note: Want only new entries that was not in the past. Tried…
I am using laravel framework to develop web application ,i am using soft-deletes so while fetching the data from database i have to check weather the column is null or not ,for that i wrote a following query QueryBuilder $today=…
SELECT #Opportunity Details o.Id AS 'Opportunity ID', o.Name As 'Opportunity', o.Project_Assigned__c AS 'PM Assign Date', CASE WHEN o.StageName IN ('Best Case','Commit','Committed','Discover and Assess','Pipeline','Probable','Sales Qualification','Upside') THEN 'Pre-Sales' WHEN o.StageName IN ('Omit - Closed','Omit from Forecast','Omit-Closed','Omitted') THEN 'Omit' WHEN o.StageName IN ('Rejected','Lost','Cancelled')…