[Chase]

SELECT * FROM table WHERE FIELD_ONE = '1' AND FIELD_ONE = '1'I need this to print out 2 rows even though they are the same, it currently only prints one. how would you do this?

[Harold L]

The two parts of the AND are redundant...SELECT * FROM table WHERE FIELD_ONE = '1'FETCH FIRST 2 ROWS ONLY;Or just open a cursor in your application and FETCH twice before closing the cursor.