For me the most recent thing was CTE's (Common Table Expressions), best way to make SQL readable, instead of ugly encapsulation of every sub select you can give it nice names and easy structure.
here an example:
with my_cte as
(
select id, t.* from some.table t where
),
2nd_select as
(
select fk_id as id, t.* from awesome.table t
)
Select * from my_cte a
Inner join 2nd_select b on a.id = b.id
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
For me the most recent thing was CTE's (Common Table Expressions), best way to make SQL readable, instead of ugly encapsulation of every sub select you can give it nice names and easy structure.
here an example:
with my_cte as
(
select id, t.* from some.table t where
),
2nd_select as
(
select fk_id as id, t.* from awesome.table t
)
Select * from my_cte a
Inner join 2nd_select b on a.id = b.id