The subqueries you are using in your select statement should return single value for your query to run without error. The following query will run without any issue, but it won’t give you the result you are expecting. SELECT TOP 10 (SELECT g_name FROM vgsales$ x WHERE g_platform = ‘X360’ AND a.g_rank = x.g_rank) AS … Read more
I will make the assumption that there is at least one record in sales_flat_order that satisfies condition status != ‘holded’ and whose customer_email is NULL. (NOT) IN is notoriously tricky with NULLs, here is an example. Consider the following query: SELECT 1 WHERE 1 NOT IN (SELECT 2 UNION ALL SELECT 3) This yields a … Read more
You should use group by and sum, but before that, you should create two subqueries according to n_txn_type_key and then compare: select txn_type_4.n_event_key, txn_type_4.tran_amount from ( select n_event_key, sum(n_transaction_amount) as tran_amount from TABLE_NAME where n_txn_type_key = 4 group by n_event_key ) txn_type_4 inner join ( select n_event_key, sum(n_transaction_amount) as tran_amount from TABLE_NAME where n_txn_type_key = … Read more
UPDATE b SET b.c1 = b.c2 – b.c3 FROM a JOIN b ON … JOIN c ON … solved SQL Join with subquery