Tag: olap-cube

How do you I calculate the difference between two timestamps in PostgreSQL?

aggregate-functions olap-cube postgresql sql timestamp

I have a SELECT query to retrieve data I need. One of the needed data is a an “aggregate” function to select two timestamp dates and calculate the difference between them. Using several resources and websites, they all gave me save answer and it did not work: I’m getting an error on the “@”: syntax error at or near “@”

MySQL:Trying to run CUBE query -> Error in your sql syntax | LIMIT 0,25

mysql olap-cube phpmyadmin sql

I have query in my structure trying run in PHPMYADMIN. I am trying to run CUBE query for OLAP operation, this is my query : I have also tried this query : but it showing this error : I tried to open the page to check syntax but it shows page not found. Answer I don’t think MySQL supports CUBE