Condition in SQL Server query

Asked

Viewed 28 times

0

I’m having a doubt that seems silly but I can’t seem to solve

I have a table with the following fields 

IdInstallation(bigint)|NameInstallation(varchar(255))|IdGroup(FK(bigint))

I would like to make the following query in this table 

SELECT IdInstallation, NameGroup from myTable where IdGroup = NULL

However this query does not return me anything :/

What I should put in place of NULL ?

sql-server

1 answer

1


In this case we need to use ... where IdGroup IS NULL

Browser other questions tagged sql-server

You are not signed in. Login or sign up in order to post.