如何在SQL中思考? [英] How to think in SQL?
问题描述
如何停止思考每个查询的游标,程序和函数,并开始使用SQL,因为它应该是?我们是否只是通过实践转向SQL的思考,或者是否有任何魔法来学习基于集的查询语言?
如果你是真的, SQL
geek:
-
圣经一致性 是
FULLTEXT
索引到圣经
-
Luca Pacioli 的描述复式簿记的算术实际上是一个规范化的数据库模式
>
-
当
Xerxes I
通过围起一个10,000
他的男人占领,然后通过这个封闭的行军其他人,他使用HASH AGGREGATE
方法。 -
li>
应该使用
CTE
的
euro
.org / wiki / File:EUR_500_reverse_(2002_issue).jpgrel =noreferrer> 欧元纸币 ,而不是 2
。 最后,您可以在我的博客中阅读关于我如何担心和学会爱 SQL
(我几乎忘了我写了):
另外还有一篇关于主题的文章:
How do I stop thinking every query in terms of cursors, procedures and functions and start using SQL as it should be? Do we make the transition to thinking in SQL just by practise or is there any magic to learning the set based query language? What did you do to make the transition?
A few examples of what should come to your mind first if you're real SQL
geek:
Bible concordance is a
FULLTEXT
index to theBible
Luca Pacioli's Summa de arithmetica which describes double-entry bookkeeping is in fact a normalized database schema
When
Xerxes I
counted his army by walling an area that10,000
of his men occupied and then marching the other men through this enclosure, he usedHASH AGGREGATE
method.The House That Jack Built
should be rewritten using a self-join.The Twelve Days of Christmas
should be rewritten using a self-join and aROWNUM
There Was An Old Woman Who Swallowed a Fly
should be rewritten usingCTE
'sIf the
European Union
were calledEuropean Union All
, we would see27
spellings for the wordeuro
on a Euro banknote, instead of2
.
And finally you can read a lame article in my blog on how I stopped worrying and learned to love SQL
(I almost forgot I wrote it):
And one more article just on the subject:
这篇关于如何在SQL中思考?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!