Leftjoin in sql

+----+----------+--------+---------------------+
| ID | NAME     | AMOUNT | DATE                |
+----+----------+--------+---------------------+
|  1 | Ramesh   |   NULL | NULL                |
|  2 | Khilan   |   1560 | 2009-11-20 00:00:00 |
|  3 | kaushik  |   3000 | 2009-10-08 00:00:00 |
|  3 | kaushik  |   1500 | 2009-10-08 00:00:00 |
|  4 | Chaitali |   2060 | 2008-05-20 00:00:00 |
|  5 | Hardik   |   NULL | NULL                |
|  6 | Komal    |   NULL | NULL                |
|  7 | Muffy    |   NULL | NULL                |
+----+----------+--------+---------------------+

Source: tutorialspoint.com

Similar codes

0 vote153 views1 answer
Oracle last connection
SQL
15 votes152 views4 answers
Mysql where value is null
SQL
0 vote168 views2 answers
Port 5432 is already in use mac
SQL
0 vote162 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote168 views1 answer
Bitmap join index
SQL
1 vote198 views1 answer
Base64 encode sql server
SQL
0 vote163 views8 answers
Convert sql query to linq online
SQL
0 vote171 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote141 views1 answer
Java spring boot connect to sql server
SQL
2 votes143 views2 answers
How to create an empty table from an existing table
SQL