\"> time_stamp) </span><span style=\"color:#D73A49;--shiki-dark:#F97583\">=</span><span style=\"color:#005CC5;--shiki-dark:#79B8FF\"> 2020</span></span>\n<span class=\"line\"><span style=\"color:#D73A49;--shiki-dark:#F97583\">GROUP BY</span><span style=\"color:#24292E;--shiki-dark:#E1E4E8\"> user_id;</span></span></code></pre>"},{"language":"Oracle","code":"SELECT user_id, MAX(time_stamp) AS last_stamp\nFROM Logins\nWHERE EXTRACT(YEAR FROM time_stamp) = 2020\nGROUP BY user_id;","lang":"sql","html":"<pre class=\"shiki shiki-themes github-light github-dark\"

Related Tags