Member since
10-15-2024
2
Posts
2
Kudos Received
0
Solutions
10-15-2024
10:03 AM
1 Kudo
I know about CTE solution I was trying to find if the variable like SQL Server solution is there or not. I will use CTE. thanks
... View more
10-15-2024
08:24 AM
1 Kudo
There are two different examples of SQL in SQL Server 1. DECLARE @Max_date_id varchar(10) SELECT @Max_date_id = MAX(date_id) FROM t_my_table SELECT @Max_date_id 2. DECLARE @Max_date_id varchar(10) = (SELECT MAX(date_id) FROM t_my_table) SELECT @Max_date_id How can I do the same thing in "Impala Query Manager"?
... View more
Labels: