News for hackers. Stuff that matters.
Re:Top 3 ways to return TOP 10 rows by an SQL query by ww520 on Wednesday July 14, 2010 @11:50AM (#1514941)
The title of the article is misleading. It should be "Returning the FIRST 10 rows of a result set" instead of TOP 10 rows. All the sample SQL uses the natural order of the tables, but he implied ordering when he talked about other programmers sorting the result rows in program, so it's really confusing. People often mistaken the natural order of a table the same as the sorted order of a result set.
Re:Top 3 ways to return TOP 10 rows by an SQL query by adamilardi on Wednesday July 14, 2010 @01:07PM (#1515242)
True, I've seen people do crazy things when It came to pagination because they didn't think rownum would work.