BigQuery remove same ID Numbers

I Have a simple table:

I need to query above table using Google BigQuery and get below results by removing same ID numbers.

Outbut:

Thanks All for help.

Failed to get this desire output.

Answers

To achieve the desired output of removing duplicate ID numbers from the table using Google BigQuery, you can use the DISTINCT keyword in your query. Here's how you can do it:

SELECT DISTINCT ID
FROM your_table_name;

Replace your_table_name with the actual name of your table in the BigQuery dataset. This query will select only the distinct (unique) values of the ID column from your table, effectively removing duplicates.

If you encounter any issues or errors while running this query, please provide more details about the problem you're facing, and I'll be happy to assist you further.