Organizational Research By

Surprising Reserch Topic

how to select only 1 row from oracle sql


how to select only 1 row from oracle sql  using -'sql,oracle,oracle9i'

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

    
asked Sep 9, 2015 by WilliamsCrab
0 votes
6 views



Related Hot Questions



Government Jobs Opening


...