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
10643 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

How to run pl/sql statements in sql*plus?

1147

How can I get the number of records affected by a stored procedure?

1118

What is multiple columns?

1120

Is coalesce faster than isnull?

1019

what is 'mysqldump'? : Sql dba

1169

What is sql and explain its components?

1119

Can we create view in stored procedure?

1026

How can I change database name in sql?

1158

explain advantages of innodb over myisam. : Sql dba

1176

How to display the current date in sql?

1129

What is left join in postgresql?

1092

what is the difference between delete and truncate commands? : Sql dba

1119

What are the types of optimization?

1009

What is sql entity?

1175

What is the difference between row level and statement level trigger?

1072