some_user54

3 ms·

1. 1.▲
   by some_user54 8y ago

   There is no need for ranting, if you need to reuse expression from select you could simply use `LATERAL JOIN` or `CROSS APPLY`: https://blog.jooq.org/2014/01/06/the-sql-languages-most-miss... Please check com
2. 2.▲
   Oracle Database 18c XE now available(blogs.oracle.com)

   3 points by some_user54 8y ago|0 comments
3. 3.▲
   by some_user54 8y ago

   If you want to trully know how thing works I suggest great blog: http://sommarskog.se/error_handling/Part1.html http://sommarskog.se/error_handling/Part2.html http://sommarskog.se/
4. 4.▲
   by some_user54 8y ago

   Is it correct that SQL Server does not support IDENTITY(slide 29)? IDENTITY property is supported from as far as I can remember: https://docs.microsoft.com/en-us/sql/t-sql/statements/create... Second app
5. 5.▲
   by some_user54 8y ago

   "Patterns. Finally, let’s assume that we want to continuously detect whether the temperature has changed more than 20% within any five-minute period. This query is impossible to do efficiently with standard SQL." This is completel