I have not used V6.x but you can Try:
Select app_id from mytable where (app_id,seq_id) not in (select app_id,seq_id from mytable where seq_id > 1)
Andy
Quote:
Originally posted by antodomnic
In my local database, the query executed well. But when I try to ran against db2 v6.1 running under OS/390 it is not able to execute, it throws the error
SqlCode=-199 Error: illeagal use of keyword as, token is <hexstring> <charstring> <graphstring> was expected
Can't i run the script against 6.1?. My local database is 7.2 If not what's the alternative solution for my problem?
|