Your company is using WILDCARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error:
# Syntax error : Expected end of statement but got "-" at [4:11]
SELECT age -
FROM -
bigquery-public-data.noaa_gsod.gsod
WHERE -
age != 99
AND_TABLE_SUFFIX = "˜1929'
ORDER BY -
age DESC
Which table name will make the SQL statement work correctly?
A. "˜bigquery-public-data.noaa_gsod.gsod"˜
B. bigquery-public-data.noaa_gsod.gsod*
C. "˜bigquery-public-data.noaa_gsod.gsod'*
D. "˜bigquery-public-data.noaa_gsod.gsod*`
Your company is using WILDCARD tables to query data across multiple tables with similar names. The SQL statement is curr
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Your company is using WILDCARD tables to query data across multiple tables with similar names. The SQL statement is curr
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!