We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
1 parent ac0d9b2 commit f5ec335Copy full SHA for f5ec335
README.md
@@ -176,8 +176,9 @@ alter table employee drop column salary;
176
alter table employee modify column salary int;
177
```
178
179
-#### Truncate Table
+#### Truncate Table
180
```sql
181
+-- deletes all the rows from table
182
truncate employee;
183
184
@@ -279,7 +280,9 @@ select * from employee where salary > 3000 and salary < 4000;
279
280
281
#### BETWEEN and AND
282
283
+
284
select * from employee where salary between 3000 and 4000;
285
+-- it also includes 3000 & 4000
286
287
288
### OR
0 commit comments