Could someone help me construct query to find location that only has HP in below table;vendor locationHP TXCisco TXDell TXHP CAHP WADell WAHP ORCisco ORHP WIDell WICisco WI

Hi Alex_Kim245 -- Try something like the query below. Take care. SELECT Vendor ,VendorLocation FROM Vendor WHERE Vendor = 'HP'

This will not work because TX has Cisco and Dell also. I'm trying to get the ones that only have HP.

Hi Alex_Kim245 -- Apologies, I misunderstood. Something like the query below might work. Take care. SELECT * FROM ( SELECT Vendor ,VendorLocation ,row_number() over (partition by VendorLocation order by Vendor) as rownum FROM Vendor ) t WHERE rownum = 1 AND Vendor = 'HP'

Getting syntax error in From clause.

Hi Alex_Kim245 -- What is the error, please?

Sql query | Microsoft Community Hub

bake13
Microsoft
Jan 26, 2022
Hi Alex_Kim245 --

Try something like the query below. Take care.

SELECT Vendor ,VendorLocation FROM Vendor WHERE Vendor = 'HP'
- Alex_Kim245
  Copper Contributor
  Jan 26, 2022
  This will not work because TX has Cisco and Dell also. I'm trying to get the ones that only have HP.
  - bake13
    Microsoft
    Jan 26, 2022
    Hi Alex_Kim245 --
    
    Apologies, I misunderstood. Something like the query below might work. Take care.
    
    SELECT * FROM ( SELECT Vendor ,VendorLocation ,row_number() over (partition by VendorLocation order by Vendor) as rownum FROM Vendor ) t WHERE rownum = 1 AND Vendor = 'HP'

Forum Discussion

Sql query