SQL - not exists

Question

I couldnt find a clear answer to this questions, should be a simple one. Basically I am trying to get all computers that dont have word installed. This query seems to be giving me wrong data. Any ideas? Thanks!

 SELECT DISTINCT Name FROM dbo.vComputer AS v WHERE Name NOT IN ( SELECT Name FROM dbo.vComputer WHERE (dbo.vComputer.installedsoftware LIKE N'%word%')))

What's wrong about it? Are there other strings in installedsoftware that contain word? — D Stanley
– D Stanley, Commented Jan 31, 2014 at 14:58
So we don't know what the data in your table looks like, we don't know what data you expect to get from your query, and we don't know what wrong data you're getting instead, and you expect help? Sure, why not. — lanzz
– lanzz, Commented Jan 31, 2014 at 15:00
Provide sample data and expected results. Your query cannot be understood out of context. — Gordon Linoff
– Gordon Linoff, Commented Jan 31, 2014 at 15:03

Amarnath Balasubramanian · Accepted Answer · 2014-01-31 17:13:15Z

Try like this

With NOT EXISTS

SELECT Name FROM dbo.vComputer AS V WHERE NOT EXISTS ( SELECT Name FROM dbo.vComputer AS S WHERE S.installedsoftware LIKE N'%word%' )

WITH NOT IN

SELECT Name FROM dbo.vComputer AS V WHERE Name NOT In (SELECT Name FROM dbo.vComputer AS S WHERE S.installedsoftware LIKE N'%word%' );

Collectives™ on Stack Overflow

SQL - not exists

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related