Data Engineer Pertanyaan dan Jawaban Wawancara
Question: What is the difference between a left join and an inner join in SQL?Answer: An inner join returns only the rows where there is a match in both tables, while a left join returns all rows from the left table and the matched rows from the right table.Example:
|
Simpan untuk Revisi
Bookmark item ini, tandai sebagai sulit, atau masukkan ke dalam set revisi.
Masuk untuk menyimpan bookmark, pertanyaan sulit, dan set revisi.
Apakah ini membantu? Ya Tidak
Most helpful rated by users:
- What is a schema in the context of databases?
- Explain the concept of ETL in the context of data engineering.