Question: I have the following table and data setup: CREATE TABLE EMPLOYEE ( empId INTEGER AUTO_INCREMENT PRIMARY KEY, name TEXT NOT NULL, dept TEXT NOT NULL ); INSERT INTO EMPLOYEE(name, dept) VALUES ('Clark', 'Sales'); INSERT INTO EMPLOYEE(name, dept) VALUES ('Dave',…
I'm working in a multi-tenant software to manage inventory of products and I'm having difficulties to create a query to bring products inventory based on quantity criteria. Use case: Bring all products with all their inventory from all warehouses from…
I expect the SQL-Statement to update a limited amounts of rows, instead of every row: UPDATE Join_Test_1 SET ANumber = 3 FROM Join_Test_1 AS ST1 INNER JOIN Join_Test_2 AS ST2 ON ST1.PKID = ST2.PKID; I expect the statement to behave…
I have a query (PostgreSQL 15.4) like this: Select p."prodId", p."prodDesc", p."areaName", x."location1" as "Location" From ops."Products" p Inner Join ops."Locations" x on p."prodId" = x."prodId" and p."areaName" = x."areaName1" Here's the caveat: in the table Locations, there are three…
I have 2 tables: book_users and assign_book_users. they look like the image below respectively. id book_id user_id status 1 11 33 open 2 44 54 closed 3 11 98 pending 4 12 33 open 5 23 99 open 6 24…
I want to join columns from several tables. For one table join works fine select org.catalog_truck.plate_number as "Госномер грузовика", shift_id as "ID смены", trip_id as "ID рейса", * from core.monitoring_stages join org.catalog_truck on vehicle_id = org.catalog_truck.catalog_truck_id where gen_id = (SELECT…
DBMS: PostgreSql, but MySql is acceptable as well I have 4 tables, permissions id slug allowed 1 create true 2 edit true 3 delete true 4 edit false roles id slug 1 Admin 2 Manger 3 User model_permissions model_type model_id…
My problem is how to make the MySQL optimizer use a composite index in the most effective way. I am using MySQL Server 8 and have a MyISAM table containing daily statistics for 'cell' objects for a period of 2…
I tried to return some of the rows in table service: SELECT ps.post_name as post, c.cname, p.place, s.date_from, s.date_to, e.emp_name as employee, s.court, s.place FROM `service` s INNER JOIN `employee` e ON s.empno = e.empno INNER JOIN `posts` ps ON…
I have two tables T1 and T2. I'm doing a simple inner join select t1.a, t1.b, t1.c from T1 t1 inner join T2 t2 on t1.c = t2.c Table T1 has got 2 million rows and T2 has got 4…