Follow along with the video below to see how to install our site as a web app on your home screen.
Anmerkung: This feature currently requires accessing the site using the built-in Safari browser.
SQL> desc empInfo;
Name Null? Type
----------------------------------------- -------- ----------------------------
ID NUMBER(38)
PERSNO NUMBER(38)
DATA NUMBER(38)
CREATE_DATE DATE
ID PERSNO DATA CREATE_DATE
---------- ---------- ---------- -------------------
1 1 1 2005-05-22 09:36:31
2 2 1 2005-06-01 09:36:44
3 3 1 2005-06-21 09:37:00
4 4 2 2005-07-31 09:37:19
5 5 2 2005-08-30 09:37:26
SQL> select a.* from empInfo a left join empInfo b on a.data = b.data
2 and a.create_date < b.create_date where b.id is null;
ID PERSNO DATA CREATE_DATE
---------- ---------- ---------- -------------------
3 3 1 2005-06-21 09:37:00
5 5 2 2005-08-30 09:37:26