You should be able to do LIMIT in Oracle using http://www.oracle.com/technetwork... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		AlisdairO on Feb 28, 2014 \| parent \| context \| favorite \| on: Unicode support in MySQL is... You should be able to do LIMIT in Oracle using http://www.oracle.com/technetwork/issue-archive/2006/06-sep/... . If you want a standards-compliant way to do it, you can use the ROW_NUMBER() window function. This might not be as fast, but will work on virtually every DB except MySQL...

willvarfar on Feb 28, 2014 [–]

Yes I'm deep beyond correctness and now want to make it fast...

Oracle is like COBOL; the only techies who like it are those whose job security depends upon it ;)

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact