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_,