Home
Recent Q&A
Java
Cloud
JavaScript
Python
SQL
PHP
HTML
C++
Data Science
DBMS
Devops
Hadoop
Machine Learning
Azure
Blockchain
Devops
Ask a Question
Write an Oracle SQL query to get the date and time of the last 10 logins for a specific user.
Home
Oracle
Write an Oracle SQL query to get the date and time of the last 10 logins for a specific user.
0
votes
asked
Jan 21
in
Oracle
by
rajeshsharma
Write an Oracle SQL query to get the date and time of the last 10 logins for a specific user.
oraclesqlquery
Please
log in
or
register
to answer this question.
1
Answer
0
votes
answered
Jan 21
by
rajeshsharma
SELECT login_time
FROM UserLogins
WHERE user_id = 'specific_user_id'
ORDER BY login_time DESC
FETCH FIRST 10 ROWS ONLY;
Related questions
0
votes
Q: Write an Oracle SQL query to ensure only users with the manager role can insert rows into the performance_reviews table.
asked
Jan 23
in
Oracle
by
SakshiSharma
oraclesqlquery
0
votes
Q: Write an Oracle SQL query to find employees who earn more than their managers.
asked
Jan 21
in
Oracle
by
rajeshsharma
oraclesqlquery
0
votes
Q: Write an Oracle SQL query to find the average salary of employees within each department.
asked
Jan 21
in
Oracle
by
rajeshsharma
oraclesqlquery
0
votes
Q: Write an Oracle SQL query to find the five most common names in the Employee table.
asked
Jan 23
in
Oracle
by
SakshiSharma
oracle-query
0
votes
Q: Write an Oracle SQL query to find the names of employees not assigned to any project.
asked
Jan 23
in
Oracle
by
SakshiSharma
oracle-sql
0
votes
Q: Write the SQL query to get the third maximum salary of an employee from a table named employees.
asked
Nov 8, 2021
in
Sql
by
rajeshsharma
sql-query
0
votes
Q: How does the Oracle Query Optimizer determine an execution plan for a query?
asked
Jan 21
in
Oracle
by
rajeshsharma
oracle-query-optimizer
+1
vote
Q: Write a query to display a list of tables owned by the user.
asked
Jul 29, 2020
in
Oracle
by
Hodge
#oracle
0
votes
Q: How can we view last record added to a table in Oracle?
asked
Jan 19
in
Oracle
by
AdilsonLima
oracle-interview-questions-answers
0
votes
Q: Write query to print date in different language of india like Kannada, Marathi and Sanskrit
asked
Jan 26, 2021
in
Sql
by
SakshiSharma
#sql-query
sql-language
...