SHOW TOP 1 in ORACLE

Question

Here's the query

SELECT concat(FIRSTNAME,LASTNAME) AS NAME, HIREDATE from EMPLOYEE ORDER BY HIREDATE
WHERE ROWNUM = 1;

I've been trying to use rownum function but I keep getting the error - "ORA-00933: SQL command not properly ended".

Answer 1

You can try like this:

SELECT *
  FROM (SELECT concat(FIRSTNAME,LASTNAME) AS NAME, HIREDATE from EMPLOYEE ORDER BY HIREDATE  )
 WHERE ROWNUM = 1;