Question

Write an Oracle SQL query to get the date and time of the last 10 logins for a specific user.

Answer 1

SELECT login_time

FROM UserLogins

WHERE user_id = 'specific_user_id'

ORDER BY login_time DESC

FETCH FIRST 10 ROWS ONLY;