How to select only 1 row from oracle sql?

Question

I want to use oracle syntax to select only 1 row from table DUAL. For example, I want to execute this query:

SELECT user 

  FROM DUAL

...and it'd have, like, 40 records. But I need only one record. ...AND, I want to make it happen without a WHERE clause.

I need something in the table_name field such as:

SELECT FirstRow(user) 

  FROM DUAL

Answer 1

Try using ROWNUM like this:

SELECT user FROM Dual WHERE ROWNUM = 1

For detailed information, refer to this: http://docs.oracle.com/cd/B19306_01/server.102/b14200/pseudocolumns009.htm