Advertisement
DimitarVasilev

Untitled

Jun 9th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. SELECT name, creation_date
  2. FROM (SELECT name, creation_date, rownum rn
  3.   FROM (SELECT a.name, a.creation_date
  4.     FROM attach_doc a
  5.     WHERE a.name NOT LIKE '%.jpg' AND a.name NOT LIKE '%.gif'
  6.     ORDER BY a.creation_date))
  7. WHERE rn =2;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement