But this will select records which has values 2. Here is my situation.

I have a table with app_id, Seq_id, Seq_data. For a particular app Id, I may have multiple inserts ie my seq_data holds max 4000 char a row.
I have some times data which can come up to 20,000. So my db2 v 6.1 on os 390, inserts multiple rows like,

app_id seq_id seq_data
21 1 some data.....
21 2 some data.....
21 3 some data.....


In some scenarios, I have only one row which contains the seq_id "1". I just want to get this.

Hope this clarify you.
Thanks,
Anto.