Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Remove Extra column which is automatically created in table

With
Chat_Kernel as (

SELECT
conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer, chat_duration_in_seconds, queue_duration_in_seconds, visitor_livechat_id, visitor_nick, visitor_ip, visitor_email, last_operator_id, group_name, rate, last_rate_comment, goal_action_name
FROM `YourDB`
LIMIT 1000
),
NewQ1 as (
SELECT
conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer,
ROW_NUMBER() over(partition by conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer)

FROM Chat_Kernel

ORDER BY conferenceId, chat_creation_date_Asia_Kolkata, chat_start_date_Asia_Kolkata, chat_start_url, referrer

)

SELECT NewQ1.*,
from NewQ1

 

I have written the code and i want to remove Extra column which is automatically created in table and the column name is f0_,

0 1 232
1 REPLY 1