DB2 And ACCESS - Limitation Of The Query Result?
How can I limit the number of rows in the result of my query ?
(with DB2 and ACCESS)
The equivalent of
WHERE ROWNUM < 100
with ORACLE
I think it's something like
FETCH FIRST n ROW
for DB2 but I'm not sure
And I don't know for ACCESS...
(with DB2 and ACCESS)
The equivalent of
WHERE ROWNUM < 100
with ORACLE
I think it's something like
FETCH FIRST n ROW
for DB2 but I'm not sure
And I don't know for ACCESS...
Have you tried 'SELECT TOP n '
Where n is the number of rows you want?
or you can do SELECT TOP n PERCENT where n is the percent of
rows needed?
Where n is the number of rows you want?
or you can do SELECT TOP n PERCENT where n is the percent of
rows needed?
if you first create a query within Access, and then select the dropdown box from the menu bar which will probably contain "All", and change this to one of the other numbers, eg 100, or 25%, and then click on the SQL
button to the far left, it should show you the code generated.
in DB2 SQL I'm sure you've got it right - Fetch First n Rows
in DB2 SQL I'm sure you've got it right - Fetch First n Rows
Have you tried 'SELECT TOP n '
Where n is the number of rows you want?
or you can do SELECT TOP n PERCENT where n is the percent of
rows needed?
Where n is the number of rows you want?
or you can do SELECT TOP n PERCENT where n is the percent of
rows needed?