| sequel related [message #372429] |
Tue, 13 February 2001 02:14  |
Anjali
Messages: 7
Registered: February 2001
|
Junior Member |
|
|
Assuming that my database holds 100000 records and i give a query which returns 800 records.
1>
If i append a limit 10 to the query,it returns the first 10 records.Is this from the main table or the SQL area??
|
|
|
|
| Re: sequel related [message #372520 is a reply to message #372429] |
Mon, 19 February 2001 04:43  |
Pavan Kumar
Messages: 10
Registered: October 2000
|
Junior Member |
|
|
Hi,
If I understand ur question properly, you want to know if you have given a condition like rownum <10 and want the query returns 9 rows. Actually this relates to the SQL area and does not concern with the actual table as it has many records which match ur condition but u are filtering out the number of records.
Hope this answers ur query.
Pavan
|
|
|
|
| Re: sequel related [message #372521 is a reply to message #372429] |
Mon, 19 February 2001 05:02 |
Pavan Kumar
Messages: 10
Registered: October 2000
|
Junior Member |
|
|
Hi,
If I understand ur question properly, you want to know if you have given a condition like rownum <10 and want the query returns 9 rows. Actually this relates to the SQL area and does not concern with the actual table as it has many records which match ur condition but u are filtering out the number of records.
Hope this answers ur query.
Pavan
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
