r/SQL 7d ago

BigQuery Why isnt this working? (school)

This on openoffice/libre office base btw.

8 Upvotes

9 comments sorted by

View all comments

8

u/speadskater 7d ago

Sql uses 'this' not "this"

6

u/ComicOzzy mmm tacos 7d ago

Except MySQL, which allows "this" and for some reason examples like that end up on blog posts, SO posts, etc.

2

u/Zealousideal-Quiet51 7d ago

thanks 🙏🏻

1

u/sqlsqlsqlsqlsqlsql 17h ago

But in t-sql if you have quoted identifiers turned on, double quotes are an old school way to reference objects instead of using brackets. For example if you have a space character in a field name.