/explore
|
You are here 
|
orclapex.hashnode.dev | ||
| | | | |
saeedesmaili.com
I came across this Linkedin post from a Google engineer, on a new (in preview) and very interesting BigQuery syntax: GROUP BY ALL. This will save time when writing and specially modifying complex SQL queries on BigQuery. The GROUP BY ALL clause groups rows by inferring grouping keys from the SELECT items. It will exclude expressions with aggregate and window functions, constants, and query parameters for a smart GROUP BY. So instead of GROUP BY name, city, device, browser, date or GROUP BY 1, 2, 3, 4, 5 you would use GROUP BY ALL. |
|
| | | | | ||
| | | | |
blog.cloudnueva.com
Oracle Pipelined Table Functions allow APEX devs to turn complex calculations, conditional logic, and REST service calls into simple SQL statements. |
|
| | | | | ||
| | | | |
www.martinberger.com
|
|
| | | | | ||
| | | | |
whatibroke.com
EC2 Instance Setup Create a new EC2 instance. This example was done on amazon-linux but I think it would probably be better to use ubuntu next time. If you do use ubuntu note that you'll need to use apt instead of yum and will likely have to open ports 80 and 443 on the instance.... |
|
| | | |||
