All Questions
2 questions
1
vote
2
answers
53
views
Name of SQL programming style where KEYWORDS | CRITERIA are justified to centering line
Is there a name for this kind of SQL programming style?
--Courtesy of Markus Winand of modern-sql.com/
SELECT *
FROM (SELECT cities.*
, ROW_NUMBER() OVER(PARTITION BY country ORDER BY ...
- 1,497
8
votes
2
answers
1k
views
Is this a new common pattern in Oracle Where exists ( Select NULL FROM...)?
Years ago, it was common to write
where exists (Select * from some_table where some_condition)
Last year I noticed that many t-sql scripts switched to using the number 1 instead of the star
where ...
- 12.3k