0
Denegado

I am not sure why my crosstab is not running but giving me the error message I am getting Line 2 (FROM) systax error, SELECT employee_id, ship_country, freight from orders ORDER BY 1,2 FROM crosstab('select employee_id, ship_country, SUM(freight) from ord

Boat hace 6 años actualizado por Rafał Strzaliński (Senior Engineer) hace 6 años 1

SELECT employee_id, ship_country, freight from orders ORDER BY 1,2
FROM crosstab('select employee_id, ship_country, SUM(freight) from orders ORDER by 1,2')
    AS final_result(employee_id SMALLINT, Austria VARCHAR, Finland VARCHAR, Italy VARCHAR, France VARCHAR, Germany VARCHAR, Brazil VARCHAR, Belgium VARCHAR, Switzerland VARCHAR);

Denegado

Hi,


Sorry, but can't help you. This support platform is related to database modeling tool called Vertabelo.  Please ask you question here: https://stackoverflow.com/questions/tagged/sql There is a  bigger  SQL community.