Fetch first 10 records from a table having 1000 records

abhicet2003 · New User Joined: 16 Nov 2005 Posts: 21

Could any one tell me how to fech first 10 records from a table having 1000 records

iknow · Posted: Thu Dec 15, 2005 10:08 am

Hi abhjicet2003,

Check the answer for your query

abhicet2003 · New User Joined: 16 Nov 2005 Posts: 21

Thanks this query has worked fine.

stodolas · Posted: Wed Nov 07, 2007 11:28 pm

That query will provide inconsistent results without and ORDER BY clause in your select. The requirement is poorly defined.

dick scherrer · Posted: Thu Nov 08, 2007 12:34 am

Hello,

To repeat something that has been posted many times.

There is no such thing as the first n rows in a table.

The posted query will retrieve 10 rows, but there is nothing "first" about them.

The results of that query are unpredictable.

William Thompson · Posted: Thu Nov 08, 2007 2:36 am

Why are you two responding to a two year old posting that the OP was happy with?

stodolas · Posted: Thu Nov 08, 2007 2:42 am

Wow, it just showed up on my new changes list. I didn't even look at the date stamp

dick scherrer · Posted: Thu Nov 08, 2007 2:47 am

Hi Bill,

What i saw was from today - i didn't look back at the dates

This has been asked several times recently and i just thought it was someone else with the same homework

d

HARLEEN SINGH MANN · New User Joined: 03 Aug 2007 Posts: 17 Location: Pune

Can someone please explain why is thr no last or first row in a table?

dick scherrer · Posted: Sat Nov 10, 2007 2:39 am

Hello,

Tables do not have a "start" and an "end", or a "first/last" or a "front/back". These are concepts for sequential processing.

Tables have rows that are in no particular order. If you need a result set in some order, the way to guarantee the sequence of the result set that meets the selection criteria is to specify the order in the query. If the result set is a single row, ordering is not an issue - a single row is just that.

When someone talks about the first or last rows in a table it makes no sense without specifying the order by which the first/last rows are defined.

Phrzby Phil · Posted: Mon Nov 12, 2007 8:23 pm

To slightly clarify for beginners, there may in fact be some physical order to the rows, since they are in fact stored in some kind of file structure (which the system (e.g., DB2), but not the user, must be concerned about), but no query can/should/will guarantee you consistent retrieval if you have not specified ORDER BY.

Similarly, of you do specify ORDER BY, but have sets of rows with identical values in the all of the order columns, rows within each of these sets will be presented in an arbitrary order, and maybe not even the same order each time. So - for repeated testing, you might achieve different results with the same set of data.