Search results for query: *

hi all, input TAB1 COL1 --- AAA BBB CCC How can i obtain the follow output with a SELECT maybe CASE? TAB1 COL1 --- CCC AAA BBB thanks in advance, bye

hi all, input TAB1 COL1 COL2 COL3 COL4 AAA 1 A1 1 AAA 2 A2 1 AAA 3 A3 0 BBB 9 A1 1 BBB 99 A2 1 BBB 999 A3 0 How can i obtain the follow output with an update ? output TAB1 COL1 COL2 COL3 COL4 AAA 9 A1 1 AAA 99 A2 1...

hi all, i get sqlcode -802 from this UPDATE: UPDATE taba SET afield1 = 'S' WHERE afield2 = 'I' AND afield3 IN (SELECT bfield3 FROM tabb WHERE bfield1 IN ( SELECT...

hi, i use several tools: in squirrel ok, it's work, in strsql ok but then in a tool named ksql it doesn't work... So i prefer have only one select bye and thanks

hi mikrom, i found this solution: with mytab(columnA) as ( values ('001'), ('002'), ('R03') ) select * from mytab where length(rtrim(TRANSLATE(columnA, ' ', ' 0123456789'))) > 0 bye

hi mikrom, thanks a lot but unfortunately my tool doesn't support REGEXP_LIKE. thanks

hi ALL, is there a way in sql to find a character in a column that is defined char but can contain only numbers? example: columnA '001' '002' 'R03' I need to extract just 'R03' THANKS in advance bye

Hi MIKROM, thanks, your replay is very useful. I would like to ask you what do you think about this solution ? select * from tab1 where columnA in (select columnA from tab1 GROUP BY columnA HAVING COUNT(*) > 1) and columnB not in (select max(columnB) from tab1 GROUP BY...

hi all, can i select all rows from a table where there are more rows with the same column A and i don't want to extract column A with the hight column b when there are more equal rows for columns A. example column a column b a 1 b 2 c 3 c 4 d 5 d...

hi, anyone know how to see duration of a CL job in AS400 ? thanks bye

ok. I need just this: how can i extract the opposite? lower case without corresponding upper case in the exsample table1 col1 ------ MARK mark PAUL paul john ALEX I would like to select and extract only this row: john what do you think about this solution ? select a.COL1...

just a doubt: the result table after the "on condition" is: MARK MARK MARK mark mark MARK mark mark PAUL PAUL PAUL paul paul PAUL paul paul john john ALEX ALEX correct or not ? thanks

absolutly right!! thanks so much!!

hi all, how can i extrac from a table only equal rows that are diffent just for case sensitive? exsample table1 col1 ------ MARK mark PAUL paul john ALEX I would like to select and extract only these rows: MARK mark PAUL paul thanks for any idea bye