Shouldn't FROM come before SELECT in SQL? (2011)

Re:Shouldn't FROM come before SELECT in SQL? (2011) by jasomill on Friday January 26, 2024 @12:19AM (#39139188)

COUNT is easy:

  > SELECT COUNT(*) FROM ℤ;
  ℵ₀
  > SELECT COUNT(*) FROM ℝ;
  POWER(2,ℵ₀)
  > EXEC sp_configure 'continuum hypothesis','1';  
  > RECONFIGURE;
  > SELECT COUNT(*) FROM ℝ;
  ℵ₁

While non-termination is probably best left implementation-defined (to allow caller-terminated streams of infinite results where they make sense), ORDER BY would clearly be an error where no well-defined "first" or "next" result exists.

[ Parent | on HN ]

Re:Shouldn't FROM come before SELECT in SQL? (2011) by wlindley on Friday January 26, 2024 @09:27AM (#39142942)

How fun it would be to receive a Cantor result in which as many elements from the original set as there were have been removed, leaving a set drawn from what you started with which still contains as many elements!

[ Parent | on HN ]