home
search
help
profile
liking the experience? our app is even better
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now  
showing results for sql first element
1SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC)
2    WHERE ROWNUM = 1;
3-- Oracle 12c:
4SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) 
5    FETCH FIRST 1 ROW ONLY;
6SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) 
7    FETCH FIRST 10 ROW ONLY;
8SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) 
9    FETCH FIRST 10 ROWS ONLY;
upvote
downvote