How to select only 1 row from oracle sql?
You use ROWNUM.
ie.
SELECT user FROM Dual WHERE ROWNUM = 1http://docs.oracle.com/cd/B19306_01/server.102/b14200/pseudocolumns009.htm
I found this "solution" hidden in one of the comments. Since I was looking it up for a while, I'd like to highlight it a bit (can't yet comment or do such stuff...), so this is what I used:
SELECT * FROM (SELECT [Column] FROM [Table] ORDER BY [Date] DESC) WHERE ROWNUM = 1This will print me the desired [Column] entry from the newest entry in the table, assuming that [Date] is always inserted via SYSDATE.
This syntax is available in Oracle 12c:
select * from some_table fetch first 1 row only;select * from some_table fetch first 1 rows only;select * from some_table fetch first 10 row only;select * from some_table fetch first 10 rows only;^^I just wanted to demonstrate that either row or rows (plural) can be used regardless of the plurality of the desired number of rows.)