Sql

SELECT a.USERNAME, max(TIMESTAMP) FROM DBA_AUDIT_TRAIL a
WHERE ACTION_NAME = 'LOGON' AND USERNAME IN ('MY_USER')
GROUP BY USERNAME ORDER BY 1;

PREVIOUS	NEXT

Code Example
Sql :: unique sql
Sql :: sqlyog clear cache query
Sql :: get number of rows in every table mysql
Sql :: mysql workbench
Sql :: oracle list chain steps
Sql :: postgresql find missing id
Sql :: mysql grouping functions
Sql :: SQL division of an integer by another integer get float CAST
Sql :: subquery in mysql
Sql :: Get a list of tables and the primary key
Sql :: how to join multiple table in mysql
Sql :: sql server whoami
Sql :: how to show current database in mysql
Sql :: one to one and one to many relationship
Sql :: delete row mysql
Sql :: mysql inner join
Sql :: SQL/delete
Sql :: acual month sql
Sql :: sql server inner join
Sql :: view column type sql server
Sql :: cross join sl
Sql :: postgres advance auto increment
Sql :: how to select only a certain date sql
Sql :: sql round datetime
Sql :: database passwords from dbeaver
Sql :: how to modify alter user root@localhost identified with mysql_native_password by properly
Sql :: sql insert
Sql :: update database collation in postgresql
Sql :: mysql with docker
Sql :: compare if is null sql