I am trying to run this query in SSMS and I’m getting an error, ‘Sql error number: 512. Error Message: Subquery returned more than 1 value’ MERGE datawarehouse.product t USING ( SELECT (StyleCode + ColorwaySAPID) as OptionID, ColorwayName, StyleCode, [Description], Division, lclChannel, (select [label] FROM import.enumneckline e inner join import.Product p ON e.Enumeration_Value = p.lclNeckLine2… Read More Sql error number: 512. Error Message: Subquery returned more than 1 value

There exists the following table: practice=# select * from table; letter | value | year ——–+———+—— A | 5000.00 | 2021 B | 6000.00 | 2021 C | 6000.00 | 2021 B | 8000.00 | 2022 A | 9000.00 | 2022 C | 7000.00 | 2022 A | 2000.00 | 2021 B | 1000.00 |… Read More Using subquery in conjunction with a WHERE clause

I’m learning SQL and I would like to know why I’m getting ‘Error 1: could not prepare statement (1 no such column: avg_quantity)’ when I try the following query on the w3schools WITH avg_quantity AS (SELECT AVG(OrderDetails.Quantity) FROM OrderDetails) SELECT Products.ProductName, OrderDetails.Quantity FROM OrderDetails JOIN Products ON Products.ProductID = OrderDetails.ProductID WHERE OrderDetails.Quantity > avg_quantity But… Read More SQL: "no such column" with WITH clause

A Teacher has many Students. When I am showing the Teachers list I also want to show the counts of Student for each Teachers. How can I do this by using Eloquent? I can find the Teachers from this, $teacher= Teacher::where(‘teacher_status’,’active’)->get(); I can find the Student count from this $student_count = Student::where(‘teacher_id’,’teachers.id’)->count(); How can I… Read More How to get the counts of Student for each Teachers in a single collection by Eloquent

I have table element_types with column element_type containing amount types Basic Salary and Housing Allowance, i want to produce 2 column, one for Basic Salary and another for Housing Allowance, these types are linked to another table like employees and the values for those types ..etc, so I want to make 2 separate columns and… Read More Oracle SQL Produce Multi-Columns From the Same Column With Mutual Rows Values

I have a table like this: id pallet_id action product_id qty 1 2 ADD 1 100 2 2 ADD 1 50 3 2 REMOVE 1 30 4 1 ADD 2 200 5 1 ADD 1 10 and what I need is to display available qty for product_id = 1 AND GROUP per-pallet_id. The formula is… Read More MySQL subquery return more than 1 row

I have 2 tables. current_inv and qb_inventory_levels_v. I want to join those by part_number, while also allowing it to still show rows where there is only a part number in one of those tables. Ex: part_number_a part_number_b qty_a qty_b ABCDEFG ABCDEFG 1 3 ZYXW null 2 null null WWWW null 1 The current query I… Read More Keeping unmatched rows while joining on the column the rows are in MySQL

I’m having problem to get the right result from the following tables table_buyer pkey | buyer_id | buyer_name 1 | 1 | john 2 | 2 | mike table_fruit pkey | buyer_id | fruit_name 1 | 1 | banana 2 | 1 | banana 3 | 1 | apple 4 | 2 | grape 5… Read More Mariadb 'unknown column in where clause' and get wrong result using 'count()' with 'group by' in subquery

We were given an assignment in class to provide at the minimum two different solutions to find departments, which don’t have any employees. As you can see from below I completed the task successfully. An additional solution is extra credit, which I like to get. Unfortunately, I can’t think of a third solution and was… Read More Find departments with no employees

This is my subquery: select count(a.ProcessDate), b.Market from [dbo].[FileProcessLog] a left join [dbo].[FileMaster] b on a.FileID = b.FileID where convert(date, a.ProcessDate) = convert(date, getdate()-2) group by b.Market Now I want number of rows of the result table but when I use below query I got error: select count(*) from (select count(a.ProcessDate), b.Market from [dbo].[FileProcessLog] a… Read More Count number of row from subquery which have data with groupby clause