0
Abgelehnt
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
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);
Customer support service by UserEcho
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.