TIA:
Why don�t try something like this ?...
db2 "select * from test.table fetch first 10 rows only"
Regards...
Beatriz.
Spain.
INSTITUTO NACIONAL
DE EMPLEO
MINISTERIO
DE TRABAJO
Y ASUNTOS SOCIALES
Por favor, responda a [EMAIL PROTECTED]
Destinatarios: [EMAIL PROTECTED]
CC: (cci: Buz�n de Base de Datos de Data Warehouse/B_DAT/SGIE/SSCC/INEM)
Asunto: DB2EUG: select limit
Howdy: I'm sure there is a way to do this, but I don't know *how* ... How do you get the top 10 (or, whatever number) records via the command line in DB2? On some other DB apps, there is a limit function that allows you to do something like: [snip] database=> select * from test.table limit 10 [/snip] This gets me the first 10 records. How can I do this in DB2? TIA. -XTitle: select limit
Howdy:
I'm sure there is a way to do this, but I
don't know *how* ...
How do you get the top 10 (or, whatever number)
records via the command line in DB2?
On some other DB apps, there is a limit function
that allows you to do something like:
[snip]
database=> select * from test.table limit 10
[/snip]
This gets me the first 10 records. How can I do
this in DB2?
TIA.
-X
