SQL select unique items from everyone's desk-CodePudding

CodePudding

Home > Enterprise > SQL select unique items from everyone's desk

SQL select unique items from everyone's desk

Time：05-26

I have a

The answer should be

Ty kind stranger for helping me out.

CodePudding user response：

You can use this query for searching items that are on the desk and not on the other desk:

select *
from [Office] [outer]
where not exists( select 1 from [Office] 
                  where Item = [outer].Item
                  and WhoseDesk <> [outer].WhoseDesk )

Page link：https//www.codepudding.com/Enterprise/420020.html

Prev:SQL. How to obtain unique values from table but only for 1 column?

Next:Counting length of date period and number of periods

Tags：

sql

Links：
CodePudding