SQL Notes

sql.md

Operators in the where clause

1. Equal (=)
2. Greater Than (>)
3. Less Than (<)
4. Greater Than or Equal (>=)
5. Less Than or Equal (<=)
6. Not Equal (<>)
7. BETWEEN () : Between a certain range
8. LIKE () : Search for a pattern
9. IN () : To specify multiple possible values for a column

AND, OR, NOT Operators

SELECT * FROM Customers WHERE Country='Germany' AND (City='Berlin' OR City='Munchen') AND NOT (Street='Legiendamm');

NULL Operator

SELECT * FROM Cust_table where CustID IS NOT NULL AND MobileNo IS NULL ;