Menu
I have one data table:
-------------------- ID | user | Value -------------------- 1 | 1 | 1 -------------------- 2 | 1 | 2 -------------------- 3 | 2 | 3 -------------------- 4 | 2 | 2 -------------------- 5 | 3 | 4 -------------------- 6 | 3 | 2 -------------------- I would like to SELECT all rows where value is different comparing to user 1 so the result would be rows with IDs 3 (value is 3) and 5 (value is 2)
I would do something like this (will call it A)
SELECT * FROM table WHERE user = 1 and get all the rows from user 1. Than I would select (will call it B)
SELECT * FROM table WHERE user != 1 and get all other rows. And than I would compare them WHERE A.value != B.value.
I'm stuck on how to merge everything together...
Please help!
298
The Minus Operator in SQL is used with two SELECT statements. The MINUS operator is used to subtract the result set obtained by first SELECT query from the result set obtained by second SELECT query.
Select * from any table will fetch and display all the column in that table, while Select 1 from any table will display one row with 1 without any column name.
Comparing the Results of the Two Queries Let us suppose, we have two tables: table1 and table2. Here, we will use UNION ALL to combine the records based on columns that need to compare. If the values in the columns that need to compare are the same, the COUNT(*) returns 2, otherwise the COUNT(*) returns 1.
We can compare the execution plan of the already saved query execution plan as well. To do so, just open the query execution plan in SQL Server Management Studio 2016. Once opened, right click on the execution plan, and click on the Showplan compare.
Try this:
SELECT * FROM table WHERE value NOT IN ( SELECT value FROM table WHERE user = 1) If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
