Anto,
I reiterate what I posted.
The "where seq_id = 1" will return all rows where
seq_id has 1 as a value, none others.
If this is not what you want, please restate what you are after.
Andy
Quote:
Originally posted by antodomnic
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.
|