The square brackets qualify the text within as a column name. They are required if someone, against recommendation, creates a column name the same as a reserved word. For example, if you have a column named Date, the following will error: SELECT t.Date FROM Table1 t In this case, you would need to qualify the … Read more
You have to join the the employee table twice: select distinct employee.LastName, employee.EmployeeId, manager.Lastname from customer join employee as employee on customer.SupportRepId = employee.EmployeeId join employee as manager on employee.ReportsTo = manager.employeeId where customer.Country = ‘Canada’ 0 solved SQL where clause two seperate values? [closed]
Yes, the wrong part is AUTO_INCREMENT. there is no AUTO_INCREMENT in SQL Server. It should be IDENTITY. Again, you are trying to create two IDENTITY field in your table. that’s not allowed. You can have only one IDENTITY field. start and end are reserve word. You need to escape them using [] (square brackets) You … Read more
Assuming 10,john should be 15,john this looks like a very simple join. If the below model is incorrect please copy it, edit it and add to your question. drop table if exists t1,t2,t3; create table t1(u_id int, name varchar(10), prd int); create table t2(u_id int, temp int); create table t3(u_id int, Office int); insert into … Read more
Introduction This article provides a solution to the issue of not being able to create any tables in SQL Server 2012. It explains the cause of the issue and provides a step-by-step guide on how to resolve it. It is important to note that this issue can occur due to a variety of reasons, so … Read more
You can use a query like this: SELECT t1.Title, t1.Url, t1.Description, t1.id FROM mytable AS t1 JOIN ( SELECT MIN(id) AS min_id FROM mytable GROUP BY title ) AS t2 ON t1.id = t2.min_id This will pick the record having the minimum id for each distinct value of Title. 3 solved SQL Query: Remove duplicates … Read more
How do i display the same recurring product in a table? I.e. Same product (macbook) that has been serviced at different locations solved How do i display the same recurring product in a table? I.e. Same product (macbook) that has been serviced at different locations
We can use REGEXP_EXTRACT here with a capture group: SELECT product, REGEXP_EXTRACT(product, r'([0-9]+)(?:l|ml|gr|g|mg|[a-z]+s)\b’) AS Extracted FROM yourTable; 3 solved Bigquery REGEX getting numbers only that followed by certain text (unit)
Use this: SELECT c.LastName, c.FirstName, i.InvoiceId, i.CustomerId, i.InvoiceDate, i.BillingCity, i.total FROM invoices i INNER JOIN customers c ON i.CustomerId = c.CustomerId WHERE i.BillingCity = ‘New York’ AND i.total = 10 1 solved What is the purpose of AND operator in SQL? How do I use AND in my query below?
How about: SELECT w.adharno, w.phone w_phone, descrip_w, amount_w, a.phone a_phone, decrip_a, amount_a FROM table_w w JOIN table_a a ON a.adharno = w.adharno AND w.descrip_w = a.decrip_a AND (w.phone <> a.phone OR w.amount_w <> a.amount_a) solved Tsql compare two field in the result set
This sounds like not exists: select e.* from equipments e where not exists (select 1 from contracts c where c.serial = e.serial and c.status=”active” ); solved How I return equipaments not active in another table [closed]
The following result, which isn’t an exact match to your request, but it may get you started. It doesn’t attempt to list all the starting times, but does count the number of entries per pd per date so any that are not equal to 2 can be detected easily. | ID | PD | MIN_TIME … Read more
This function should do what you want. It relies on MySQL treating boolean results as either 1 or 0 in a numeric context, thus the MAX call effectively becomes an OR of all the conditions. CREATE FUNCTION check_activity(project_id INT, check_date DATE) RETURNS BOOLEAN DETERMINISTIC BEGIN RETURN (SELECT MAX(check_date BETWEEN ActiveFrom AND ActiveTo) FROM projects WHERE … Read more
SELECT DISTINCT A.EMPLOYEENAME FROM Attendance AS A JOIN Attendance AS B ON B.LEAVE_DATE = A.LEAVE_DATE + 1 AND B.EMPLOYEENAME = A.EMPLOYEENAME JOIN Attendance AS C ON C.LEAVE_DATE = B.LEAVE_DATE + 1 AND C.EMPLOYEENAME = B.EMPLOYEENAME The inner joins will remove all employee who were not absent three consecutive days. 14 solved Find out the Employees … Read more
Get all column values to one row and find the count SQL SERVER ;WITH CTE AS ( SELECT COL1 Name FROM YOURTABLE UNION ALL SELECT COL2 FROM YOURTABLE UNION ALL SELECT COL3 FROM YOURTABLE UNION ALL SELECT COL4 FROM YOURTABLE UNION ALL SELECT COL6 FROM YOURTABLE UNION ALL SELECT COL7 FROM YOURTABLE ) SELECT DISTINCT … Read more