Use of OR Operator In Where Clause In MSSQL Database Server Tutorial Example
Run microsoft sql server management studio query editor or any client tools you like then copy & paste the below code to use OR operator in where clause and select specific columns by sql command or statement in MSSQL Database Server Tutorial Example
-- Northwind
SELECT LastName, Region
FROM Employees
WHERE Region IS NULL
OR LastName LIKE '%ing%'
-- Region is null OR "ing" in LastName
Make sure that you have "Northwind" sample database available. -- is comment in MSSQL -- in fact it is comment in Oracle and MySQL as well

No comments:
Post a Comment
leave your comments here..