In this post we will discuss Comman SQL Statement, which one of the most important part for testing .Must read this ......
| P_Id | LastName | FirstName | Address | City |
| 1 | Hansen | Ola | Timoteivn 10 | Sandnes |
| 2 | Svendson | Tove | Borgvn 23 | Sandnes |
| 3 | Pettersen | Kari | Storgt 20 | Stavanger |
| 4 | Nilsen | Johan | Bakken 2 | Stavanger |
| 5 | Tjessem | Jakob | Nissestien 67 | Sandnes |
1.DELETE FROM Persons WHERE LastName='Tjessem' AND FirstName='Jakob'
2. SELECT DISTINCT City FROM Persons
Operators Allowed in the WHERE Clause
3. With the WHERE clause, the following operators can be used:
| Operator | Description |
| = | Equal |
| <> | Not equal |
| > | Greater than |
| < | Less than |
| >= | Greater than or equal |
| <= | Less than or equal |
| BETWEEN | Between an inclusive range |
| LIKE | Search for a pattern |
| IN | If you know the exact value you want to return for at least one of the columns |
Note: In some versions of SQL the <> operator may be written as ! =
4. SELECT * FROM Persons WHERE LastName='Svendson' AND (FirstName='Tove' OR FirstName='Ola')
5. SELECT column_name(s) FROM table_name ORDER BY column_name(s) ASC|DESC
6. INSERT INTO table_name (column1, column2, column3,...) VALUES (value1, value2, value3,...)
7. UPDATE Persons SET Address='Nissestien 67', City='Sandnes' WHERE LastName='Tjessem' AND FirstName='Jakob'
