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 :: find all tables where column name exists oracle
Sql :: unique sql
Sql :: how to check last index rebuild sql server
Sql :: sql not equal to operator
Sql :: create postgres role and database for bitbucket
Sql :: fetlife
Sql :: what is truncate in sql
Sql :: mysql get 2nd value in comma separated list
Sql :: python sqlalchemy orm to select null values
Sql :: how to average max mysql
Sql :: postgres show table schema
Sql :: show sql property syntax for jpa.
Sql :: List all the items that have not been part of any purchase order. sql
Sql :: SQL Copy From Two Tables to One
Sql :: left join sql
Sql :: sql insert into select statement
Sql :: sql where clause
Sql :: sql server get date of previous sunday
Sql :: Truncate a table then insert data
Sql :: mysql workbench change default value
Sql :: REMOVE DATE FROM DATE TIME SQL SERVER
Sql :: cte in sql server
Sql :: mysql allow connection from any host
Sql :: MySQL error code 2068
Sql :: sql recherche nom prenom
Sql :: mql4 sleep
Sql :: cannot connect to mysql server 10060
Sql :: postgresql add not null and not empty constraint
Sql :: mysql workbench primary key
Sql :: les jointures sql server