Skip to content

Commit 7445496

Browse files
authored
Merge pull request Cheatsheet-lang#8 from Hemshree/master
Added more Queries
2 parents da1ce06 + 31df95c commit 7445496

File tree

1 file changed

+15
-0
lines changed

1 file changed

+15
-0
lines changed

README.md

Lines changed: 15 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -282,6 +282,21 @@ select * from employee where salary > 3000 and salary < 4000;
282282
select * from employee where salary between 3000 and 4000;
283283
```
284284

285+
#### Null
286+
```sql
287+
select * from employee where salary is NULL;
288+
```
289+
290+
#### Not null
291+
```sql
292+
select * from employee where salary is NOT NULL;
293+
```
294+
295+
### ORDER BY Clause
296+
```sql
297+
select * from employee ORDER BY salary DESC;
298+
```
299+
285300
#### Like Operator
286301
```sql
287302
select * from employee where name like '%Jo%'; -- Similar to *Jo* in regrex

0 commit comments

Comments
 (0)