View previous topic :: View next topic
|
Author |
Message |
dasan
New User
Joined: 24 Oct 2006 Posts: 10
|
|
|
|
HI
To perform a DB2 SQL Select and only want to return the first 10 rows (no particular order). My normal query is 'SELECT * FROM tablename'. Do I need something special in my 'WHERE' clause? |
|
Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
|
|
|
|
Hi there,
Please specify
fetch first n row only
Code: |
SELECT * FROM table name
FETCH FIRST 10 ROW ONLY; |
|
|
Back to top |
|
|
|