Backend software engineer from India. Love databases, cloud technologies, and chess.
Nothing here yet.
Oct 24, 2023 · 16 min read · Introduction SQL is a declarative query language. That means, you tell it what you want, you do not tell it how it's supposed to get it. This blogs aims to give an intuition about how a query is internally run (on a very high-level). Understanding th...
SSameer and 1 more commentedSep 19, 2023 · 8 min read · Introduction Let's say you have 2 tables: table1: Having a column col1 table2: Having a column col2 create table table1 (col1 int); create table table2 (col2 int); Let's discuss a query: select * from table1 where col1 in (select col1 from table...
PJTAAPraneeth and 6 more commented