select * from PA_TASKS pp where pp.TASK_NUMBER in (select QQ.TASK

how to select alphabets in a one column , for this the
table name is PA_TASKS and column name is TASK_NUMBER, In
TASK_NUMBER the data like this
1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For
this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE,
Its some urgent requirement ,thanks in advance

Question Posted / vinay singh

6 Answers
10722 Views
I also Faced
E-Mail Answers

Answer Posted / vinay singh

select * from PA_TASKS pp
where pp.TASK_NUMBER in
(select QQ.TASK_NUMBER from PA_TASKS QQ
where length(trim(translate
(QQ.TASK_NUMBER,'0123456789',' '))) > 0
)

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the best sql course?

1046

What is your daily office routine?

2340

Is inner join faster than left join?

1273

What is the current version of postgresql?

1169

Is primary key always clustered index?

1092

what is schema? : Sql dba

1137

what are aggregate and scalar functions? : Sql dba

1122

what is sql server agent? : Sql dba

1179

what is dbms? : Sql dba

1061

how many tables will create when we create table, what are they? : Sql dba

1140

what are the advantages of sql ? : Sql dba

1138

how to escape special characters in sql statements? : Sql dba

1110

Is primary key clustered index?

1015

Do we need to rebuild index after truncate?

1128

If a cursor is open, how can we find in a pl/sql block?

1235