Skip to content
Advertisement

Tag: teradatasql

Changing In to Exists in SQL – with DISTINCT

Having this one: Reading this one: Changing IN to EXISTS in SQL Tried to change it into “Exists”, but produced this and it did not work: The error is 3706: Syntax error: expected something between ‘=’ and ‘DISTINCT’ keyword. Answer You have already redundant code. Inside the IN subquery you are selecting a column from ORGHEADER, so the LEFT join

No more spool space in Database (Teradata)

I am a beginner in SQL and I have a problem with one of my queries on Teradata. When I run it, I get this error: “No more spool space in Database”. According to my research on the Internet, the problem would come from the fact that my query is not optimized enough, except that I don’t see how I

Advertisement